Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between flat files and relational sources?
- 2 Answers
- 6267 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
What are the differences between sql override and update override?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
can cubes contain measures ?
What is abap? What are idocs?
What are the key benefits of ETL Testing?
How many types of transformations supported by sorted input?
Can we create Hierarchies in generic datasources?
What is initial load and what is full load?
What is the difference between project backlog and product backlog?
how do u set partition points in the mapping?
what is the use of server?
Give the benefits of data integration suite?
what is the meant by Normalization and de-normalization?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
how do u set partition points in the mapping?
