1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

task is running successfully but data is not loded why?

Question Posted / swapna

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

can we create index and drop index in exsisting table while using infomatica

4 Answers  

What is Datadriven?

2 Answers   Informatica,

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

what is row level and column level indicator?

1 Answers   TCS,




what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

Why we use stored procedure transformation?

4 Answers  

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

For more Informatica Interview Questions Click Here
Categories