Difference between flat files and relational sources?
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 is tracing level? How many types of transformations supported by sorted input?
what are the production issues in datastage?
What is granularity? Please explain with example
Explain and compare etl & manual development?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
how many maximum session supports to multiload in teradata ??
What is initial load and what is full load?
What is cube grouping?
what happens if the info.server doesn't find the session parameter in the parameter file?
Explain about hash partitioning?
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?