Difference between flat files and relational sources?
- 2 Answers
- 5601 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to fine tune mappings?
What is partitioning? Explain about round-robin, hash partitioning.
SCD2 will work on only dimension tables as well as fact Table?
What is meant by incremental load?
what is the difference steps for data modeling?
Is hadoop a etl tool?
how many steps are there in etl process?
What is staging area referring to?
What is the difference between round-robin partitioning and hash partitioning?
what is dynamic insert?
What do you understand by active and passive transformations?
What is initial load and what is full load?
what is different between sequential batch and concurrent batch and which is recommended and why?
what is the difference between cubes and package in cognos
what are the concerns of OLTP and DSS systems?
