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 |
Explain the mapping variable usage example in informatica
Which is costliest transformation? costly means occupying more memory?
What is DR strategy for Informatica project?
How can we handle two sessions in informatica?
How to load a relational source into file taget?
What are the uses of a Parameter file?
we have to use order by,where,having we to implement sql query
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
what is the difference between Informatica 7.1 and Abinitio?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
How to convert flat file into xml file? How to tune joiner?
can we generate reports in informatica ? How?