task is running successfully but data is not loded why?

Answers were Sorted based on User's Feedback



task is running successfully but data is not loded why?..

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

task is running successfully but data is not loded why?..

Answer / 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

More Informatica Interview Questions

What is Java Transformation? what are the uses of it?

0 Answers   TCS,


wf dont have integration severances how you can run?

1 Answers   TCS,


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1 Answers  


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1 Answers  


What is the function of aggregator transformation?

1 Answers  


What could be the possible resons of locks by user?

1 Answers  


can you please explain me pre session and post session options?

4 Answers   BTBP,


I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,


Explain the pipeline partition with real time example?

1 Answers   Informatica,


what is the difference between repository & Intergration service

1 Answers  


Mention few power centre client applications with their basic purpose?

1 Answers  


What are two types of processes that informatica runs the session?

2 Answers  


Categories