Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between flat files and relational sources?
- 2 Answers
- 6272 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasanna
if ur sources are flat files then you cannot give any SQ
override queries.
to join 2 flatfile sources you need to have a joiner
transformation.
If ur target is a flat file, the loading process is very
fast as its a bulk load where there will be no constraints
( no checks)
You can have number and char data types... but for dates,
you need to convert explicitly
many more diff are there...
You can use indirect method and use many flatfiles of same
structure and load to a target using one session and
workflow tasks.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / maruthi
FLAT FILES SOURCES WILL WITHOUT PRIMARY KEY AND ALL THE
COLUMN DATATYPES WILL BE SIMILER. I.E--CHAR.
RELATIONAL SOURCES WILL BE WITH PRIMARY KEY AND FOREIGN KAY
REALTION SHIP
THIA IS THE MAIN DIFFERENCE,A LOT OF SMALL DIFFERENCES ARE
THEIR.
| Is This Answer Correct ? | 3 Yes | 1 No |
What are the ETL Testing Operations?
What is ROWID explain ?
Explain about hash partitioning?
how do u implement scheduling in Informatica?
Explain the key challenges that you face while performing etl testing.
how do u really know that paging to disk is happening while u are using a lookup transform?
when will use SQL override in a lookup transformation?
what is the difference between cubes and package in cognos
what is pmrep command?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
explain the methodology of Data Warehousing?(Polaries)
list and discuss two approaches for updation of target table in Informatica and how they are different.
Teradata 
