what are the limitations for bulk loading in informatica for
all kind of databases and transformations?

Answers were Sorted based on User's Feedback



what are the limitations for bulk loading in informatica for all kind of databases and transformat..

Answer / sujana

v need to disable constraints while performing bulk loading

Is This Answer Correct ?    12 Yes 0 No

what are the limitations for bulk loading in informatica for all kind of databases and transformat..

Answer / sunil

Bulk load is used for external loaders and in bulk load we
will not write information to datalog file so if any
recovery is needed it is not possible

Is This Answer Correct ?    9 Yes 0 No

what are the limitations for bulk loading in informatica for all kind of databases and transformat..

Answer / vikas

1.update strategy
2.no constraints on target
3.target should be relational database
4.less number of records

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


what is SDLC way of code development?

0 Answers  


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


what is difference between COM & DCOM?

1 Answers   Satyam,






how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,


Explain one complecated mapping?

3 Answers   Fidelity, Wipro,


what is mapping performence?

2 Answers   Cap Gemini,


In informatics server which files are created during the session rums?

0 Answers  


How to extract original records at one target & Duplicate records at one target?

12 Answers  


can anyone suggest best free Talend data integration training online

0 Answers  


What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,


Categories