Difference between flat files and relational sources?
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference steps for data modeling?
what is session partitioning?
how many maximum session supports to multiload in teradata ??
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What are the different etl testing categories as per their function?
What is partitioning? Explain different types of partitioning?
What are the different Lookup methods used in Informatica?
where is the cache (lookup, index) created and how can you see it.
Explain do we need an etl tool?
dimension object created in oracle can be imported in designer?how?
what is the meant by Normalization and de-normalization?
what is data modeling?
how would u estimate the size of Lookup transform data and index cache?
What are the steps involved in etl process?