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 the term PIPELINE in informatica ?
What are the tasks that source qualifier perform?
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
Three date formats are there . How to change these three into One format without using expression transformation ?
What is the meaning of up gradation of repository?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
what is unit testing?tell me proceedure
What is the sql query overwrite in source qualifier in informatica
Is it possible to update the target table with PK?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
what is procedure to use mapping variable in source qualifier transformation? with example
can a port in expression transf be given the name DISTINCT