Difference between flat files and relational sources?
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 is the difference between Data Warehousing and Data Mining?
where is the cache (lookup, index) created and how can you see it.
can cubes contain measures ?
Do we need an ETL tool? When do we go for the tools in the market?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Can there be sub steps of etl steps?
what are the data modeling tools you have used?(polaris)
explain the methodology of Data Warehousing?(Polaries)
if i have a query as flat file how can we load data to target table
how do use session mapping parameters ?(in which transformation)
When do we go for the tools in the market?
Explain different types of partitioning?
When do we analyze the tables? How do we do it?
what is the difference steps for data modeling?
what is the difference between cardinality and Nullability?