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 |
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
can we override a native sql query within informatica? Where do we do it?
Explain lookup transformation is active in informatica
What does cheating measurement mean?
How to delete first 3 rows & last 3 rows in target table in informatica
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
What is a data modeling?
How can we store previous session logs?
How can you validate all mappings in the repository simultaneously?