Can flat files be stored in DWH????

Database

Can flat files be stored in DWH????

Q: Can we store  flat files in Teradata Datawarehouse?

Ans: No

Reason:Since Teradata is an RDBMS it will store all the data in the tables only.It can't store any files in the warehouse.

Please suggest whether my assumption is correct or not

Tags (1)
1 REPLY

Re: Can flat files be stored in DWH????

Is it binary or simple test file?? You can store by defining BLOB or CLOB datatype. But maximum size should not excced 2 GB...

Binary Large Object (BLOB) : Store Raw Binary data same like VARBYTE but can be defined as 2 GB in length, can be used to store images, video clips and word documents etc.

Character Large Object (CLOB): Store character data same like VARCHAR, such as simple text, HTML, or XML documents.