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
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 |
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 |
Answer / vijay
Another ans could be . If target table has index on it.
Is This Answer Correct ? | 7 Yes | 0 No |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
tell me 7.x and 8.x diferrencess(but not transformations)
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
when will we go for unconnected lookup transformation in Informatica?
What does refresh system mean, and what are its distinctive choice?
what are the limitations of pushdown optimization technique ? Advance thanks
what is target update override and when we use it?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
Target is zero file and how can you send the email?
what is diff b/t sorter t/r and agg have the option sorter property...
What is an active transformation?