Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / suresh
Here the records has to pass through the database drivers and ODBC connections are required, which is a time taking process.
But where as records from flat files are copied in easier way
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to update source definition?
Explain the different lookup methods used in informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain what is informatica metadata and where is it stored?
What is informatica worklet?
Enterprise data warehouse your projects phase by phase explain?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the transformations that are not supported in mapplet?
What is the commit type if you have a transaction control transformation in the mapping?
How many types of sessions are there in informatica.please explain them?
What are connected or unconnected transformations?
What is expression transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?