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 are the data modeling tools you have used?(polaris)
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
what is the difference between normal & bulk loading? and which one is recommended ? why?
How many types of transformations supported by sorted input?
What exact we can see in table?
what is different between sequential batch and concurrent batch and which is recommended and why?
without using ETL tool can u prepare a Data warehousing and maintaining?
what are the parts of Informatica server ?
What are the differences between sql override and update override?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What is the difference between Data Warehousing and Data Mining?