If I have a index defined on target table and if set it to
bulk load will it work ?

Answer Posted / surya

Bulk load never support the index.so if index in target with
bulk load the session will fail.so before use bulk load u
have to drop index in target and recreate index using
target post sql

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you set a varible in incremental aggregation

1441


What are ETL Tools?

664


To import the flat file definition into the designer where should the flat file be placed?

673


what is SDLC way of code development?

1555


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

612






How can one identify whether mapping is correct or not without connecting session?

876


What is a difference between complete, stop and abort?

639


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1585


Why sorter is an active transformation?

746


What is the scenario which compels informatica server to reject files?

600


What is meant by incremental aggregation?

579


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1893


What are the tuning techniques you applied during your last project

1560


What is data transformation manager process?

619


Different circumstance which drives informatica server to expel records?

549