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
- 18972 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
What is the difference between source qualifier transformations source filter to filter transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Which is the t/r that builts only single cache memory?
What do you mean by blocking transformation?
How is union transformation utilized?
Make a note of the quantity vaults made in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What you know about transaction control transformation?
How we can create indexes after completing the load process?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Mention few advantages of router transformation over filter transformation.
What is meant by incremental aggregation?
How do you take back up of repository?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a dimensional model?
