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
- 19424 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjay
While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain target update override in informatica
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How many transformations can be used in mapplets.
How can you differentiate between powercenter and power map?
define galaxy repository in informatica
What is the status code in stored procedure transformation?
What are some examples of informatica etl programs?
How do you use reject loader.
What is workflow manager?
Explain the different kinds of facts.
Which transformation should we use to normalise the COBOL and relational sources?
How to call shell scripts from informatica?
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?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Design time, run time. If you don't create parameter what will happen
