task is running successfully but data is not loded why?
Answer Posted / krishnakanth.ch
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 |
Post New Answer View All Answers
How can we remove the duplicates from flat file source?
What are the designer tools for creating transformations?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to load last n records of file into target table - informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What does update strategy mean, and what are the different option of it?
How many input parameters can exist in an unconnected lookup?
my source is junk data how will u remove that junk data by using unix please any one replay me
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What is rank transform?
Describe the impact of several join conditions and join order in a joiner transformation?