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 diff b/w target load plan and cbl?
Sequence generator, when you move from develoment to production how will you reset
Explain how to import oracle sequence into informatica?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
How union transformation is used?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
What happens when a session fails and you click on recover?
what is diff between IN and EXIT commands
What is the different lookup cache(s)?
Diff b/w ShortCut and reusabel Object ?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?