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

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

Answer / vijay

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

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

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

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....

Answer / senthil kumar s

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

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.....

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

Answer / vino

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

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

Explain sessions and how many types of sessions are there?

0 Answers  

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

How Union Transformation is an Active Trans?

6 Answers  

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

What are session parameters ? How do you set them?

0 Answers  

What is the command used to run a batch?

0 Answers  

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,