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
What is the difference between STOP and ABORT options in Workflow Monitor?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Partition, what happens if the specified key range is shorter and longer
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what are the Methods For Creating Reusable Transformations?
What is the commit type if you have a transaction control transformation in the mapping?
What do you mean by worklet?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What happens when a session fails and you click on recover?
What is transformation?
What are the components of Informatica? And what is the purpose of each?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we get 1st record through Informatica(without sequence number).
Write the prerequisite tasks to achieve the session partition?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do