If a workflow stops or fails after loading 10k records ?
How can you recover it and If there is no order while
reading data from source ?
Answers were Sorted based on User's Feedback
Answer / abhinaw prakash
Informatica has something called Recovery option for
recovering data.
If we have provided commit after say 10k records then it ll
start from where it failed i.e @ 10k.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / prateek singh rana
informatica has one property in session level called
recovery stragy, we use it and take as ''resume from last
check point'' and run the workflow on recovery mode.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a sorter transformation?
what is lookup chache?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What are the mapping paramaters and mapping variables?
What is workflow? What are the components of workflow manager?
What are the different types of Type2 dimension maping?
Could any one to tell Fact table Partitioning?
Which transformation should u need while using the cobol sources as source defintions?
What is the difference between procedure and stored procedur?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
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 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Performance wise which is better joiner or look up ? Give me with example?