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 |
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
what is the difference between OLTP database and data warehousing database?
what are the parts of Informatica server ?
Is hadoop a etl tool?
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
what happens if the info.server doesn't find the session parameter in the parameter file?
how do use session mapping parameters ?(in which transformation)
Explain etl mapping sheets?
Explain me ETL project architecture in Detail?
What are cubes and olap cubes?
When do we analyze the tables? How do we do it?