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 |
What is metadata reporter?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is domain and gateway node?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
what is the main advantage of unconnected lookup
can you use flat file for lookup table?why?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
What does role playing dimension mean?
How do you implement unconn. Stored proc. In a mapping?
Explain what are the different types of transformation available in informatica.
What is expression transformation?
Does an informatica transformation support only aggregate expressions?