task is running successfully but data is not loded why?
Answers were Sorted based on User's Feedback
Answer / bala govi
Either your SQL Override is not reading any records, or
your update stregy is not using the correct condition or
check the task SQL Override and check the properties and
make sure "Enable Test Load" is turned off.
Hope this helps
Bala
| Is This Answer Correct ? | 0 Yes | 0 No |
There could be many possibilites:
1) Data are getting rejected due to primary key violation
2) The conditions given in filter or router or update are
satisfying.
3) Make sure 'Enable Test load' option is not enabled.
4) Check for any post sql override in the session
Properties.
| Is This Answer Correct ? | 1 Yes | 1 No |
Can we have a Mapping without a Source Qualifier?
How to use pmcmd utility command?
Two different admin users created for repository are ______ and_______
If there are more than one sessions running parallel in a worklet, which will be the last session ?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is confirmed fact in dataware housing?
what are the different types of transformation available in informatica and what are the mostly used ?
What is Performance tuning in Informatica?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
what is song in infrmatica...?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
Different sorts of metadata that stores in the storage facility?