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 eliminate duplicate rows from flatfile,explain?

3 Answers  


Difference between task flow and linear task flow

0 Answers  


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  


By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  


Which is the t/r that builts only single cache memory?

0 Answers  






if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,


how to connect two or more table with single source qualifier?

4 Answers   IBM,


in which situations do u go for scds ?

3 Answers   TCS,


What are Rapid changing dimensions?

1 Answers  


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,


What are the modules in Power Center

0 Answers  


Categories