Work flow failed when it is set to Bulk mode but it was
successful
when set to normal mode y??(All the connections are fine and
exactly
correct)?
Answer Posted / janardhanreddy yerraballi
Sometimes in bulk mode the session gets failed bcoz you cannot use bulk mode if the index is defined on the target table, so if you want to use bulk mode for indexed target table you have to drop abd recreate the index using pre and post sql command
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the different types of transformation available in informatica.
Differentiate between source qualifier and filter transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is lookup transformation?
Briefly define reusable transformation?
In warehouses how many schemas are there?
What is meant by incremental aggregation?
Please let me know how to make encryption and decryption with example?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Briefly explain the aggregator transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
how to load dimension table and fact table. plz tell me the steps.
What are data-driven sessions?