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 |
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
What are the new features of informatica 9.x developer?
What are the different components of powercenter?
Partition, what happens if the specified key range is shorter and longer
What is olap (on-line analytical processing?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
how to through logic of informatica using the push down optimization into oracle.
Why should we use star schema in datawarehouse design?