task is running successfully but data is not loded why?
Answer Posted / 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 View All Answers
Differentiate between Load Manager and DTM?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain in detail about scd type 1 through mapping.
What are multi-group transformations?
Explain the informatica workflow?
What is a joiner transformation and why it is an active one?
Explain sessions. Explain how batches are used to combine executions?
What is the sequence generator transformation in informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is meant by target load plan?
draw informatica architecture 8.6 ?
What is Data Caches size?
How do you load only null records into target?