can we use bulk loading when we use look in mapping



can we use bulk loading when we use look in mapping..

Answer / sayan

yes we can use bulk load if we are using static lookup.
condition: 1. we are not using a dynamic lookup on the target table. 2. There is no duplicate in the record in the data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is correlated query?

2 Answers   IBM,


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,


I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,






Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,


Write the unconnected lookup syntax?

0 Answers  


write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,


I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  


What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,


How do we call shell scripts from informatica?

0 Answers  


Differentiate between joiner and lookup transformation?

0 Answers  


Categories