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 happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  


Explain the pipeline partition with real time example?

0 Answers   Informatica,


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,


what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,


If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,


what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,


what is difference between mapping and mapplet ?

2 Answers   TCS,


difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  


How to load last n records of file into target table - informatica

0 Answers   Informatica,


what is constraint based loading

2 Answers   IBM,


what is row level and column level indicator?

1 Answers   TCS,


Categories