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)?

Answers were Sorted based on User's Feedback



Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / satya

Hi floks,

There some limitations to the BULK mode. U cant use BULK
mode in the below cases.

1. target table is not relational
2. if the target is relational but a primary key is declared
or Index is created on any of the columns.
3. If the mapping contains Update strategy.

So as per myunderstanding issue could be any one of the
above reasons. Pls check.

Satya

Is This Answer Correct ?    17 Yes 0 No

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / srinivasarao.jammu

bulk mode option wil bypass logs.... if we want to load the
data in bulk load option... we have 2 solutions
first solution is we have to remove our constraints in
target data... second is while we creating database
connection ,,, enable the parrelel mode option... check
properly ....again thankq for ur question

Is This Answer Correct ?    15 Yes 1 No

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / vijay

Another ans could be . If target table has index on it.

Is This Answer Correct ?    7 Yes 0 No

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / sanju_yu

U all are wrong my friend,
workflow failed cuz mapping maust be having a Update
strategy Transfn in it so when we use a Update strategy
Transfn u cannot run a workflow in bulk mode it should be
run in normal mode only


Thanks
Sanjay

Is This Answer Correct ?    7 Yes 3 No

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / pankaj pandey

Hi,

If you are using connection for bulk load, no other session
should use it for Normal load, otherwise it will fail. You
should have seprate connection specifically for Bluk load.

I hope this will solve your issue.

Pankaj

Is This Answer Correct ?    3 Yes 0 No

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / imran

Hi Srinivas and Upender, thanks for ur answers....another
answer for this ques which I got to know is for update
strategy we should always set work flow to normal and for
this ques i guess it is the apt answer. Please correct me if
I am wrong....if this answer is correct can u please explain
whts the reason for tht??? Thnks....

Is This Answer Correct ?    2 Yes 0 No

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / senthil kumar s

Treat Source Record type as -- INSERT
We need to set for BULK LOAD.Other cases it will fail

Is This Answer Correct ?    1 Yes 0 No

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / imran

Thanks Sanjay, this is wht I said(plz review my answer once
again)....the ques never said tht there is an update
strategy,,,,its just a guess...wht if the there is no UST
and the prob still continues???? plz reply.....

Is This Answer Correct ?    0 Yes 0 No

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / 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

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All..

Answer / vino

If u are using any row level trigger that should be
disabled....otherwise the workflow will fail...

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

Can we override a native sql query within informatica?

0 Answers  


What is critical mapping?

2 Answers  


tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,


Hi experts, can anyone tell how much we use plsql in real time

3 Answers  


What is IQD file?

1 Answers  






What all join we can perform in LOOKUP transformation?

0 Answers  


How to generate sequence numbers using expression transformation?

0 Answers   Informatica,


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  


What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  


what is upstream and downstream transformation?

7 Answers  


How to import oracle sequence into Informatica?

3 Answers   Satyam,


What is power play plug in?

2 Answers  


Categories