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

expain about the tune parameters?

0 Answers   TCS,


S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,


what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,


How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,


what r the values tht r passed between informatics server and stored procedure?

1 Answers  


In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  


In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,


hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,


wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,


Explain scd type 3 through mapping.

0 Answers  


Explain what transformation and how many are there in informatica?

0 Answers  


Categories