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 source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
What are the different types of repositories created using informatica?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
What is informatica?
Explain constraint based loading in informatica
Write the unconnected lookup syntax and how to return more than one column.
What are the components of workflow manager?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
What is the difference between Power Centre and Power Mart?
How we can create indexes after completing the load process?