can we use bulk loading when we use look in mapping

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of transformation available in informatica.

626


What is domain and gateway node?

686


can anyone explain me about retail domain project in informatica?

7417


How to configure mapping in informatica?

669


How do you handle two sessions in Informatica

653






Whats the difference between informatica powercenter server, repositoryserver and repository?

666


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1644


How to create or import flat file definition in to the warehouse designer?

606


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

626


Explain transaction control transformation in informatica

755


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1676


What are the components of the workflow manager?

633


Describe data concatenation?

563


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3438


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1615