Interested to Buy Any Domain ? << Click Here >> for more details...
Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 19420 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rayudu
another reason is that when we load the data into table
integration service also verifies data type and will do
parsing if needed. But in case of flat file there is no need
of parsing and checking data types.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Different sorts of metadata that stores in the storage facility?
scenario where i can use only concurrent execution of workflow.
What is a stored procedure transformation?
What is native users?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Difference between Target-based loading and constraint-based loading?
What is expression transformation?
What is a repository? And how to add it in an informatica client?
Differentiate between sessions and batches?
How to load last n records of file into target table - informatica
Explain the different dimensions.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is lookup transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
