Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / nidhi
To write data in table informatica server generate the insert statement for each row where as for flat file write the data row wise in file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is option by which we can run all the sessions in a batch simultaneously?
How to extract sap data using informatica? What is abap? What are idocs?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How can we remove the duplicates from flat file source?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Plz can any one say me how to get the informatica certification materials and dumps
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
In warehouses how many schemas are there?
What is workflow monitor?
What is workflow? What are the components of the workflow manager?
What are the informatica performance improvement tips
How would you join a node to the already existing domain?
What do you understand by SOA of Informatica?