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 r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
What is rank transformation?
What is aggregate awareness?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
What is a shortcut and copy in Informatica and how two are different with each other?
what is the predefined port in dynamic lookup
Which is better performance wise database or file?How?
who to split dimentions into sub dimention
Without using Lookup & Sequence Generator, How to generate Sequence?
what is the difference between mapplet & stored procedure?
in which situations do u go for sequence generator ?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,