How do you load only null records into target? Explain through mapping flow.
No Answer is Posted For this Question
Be the First to Post Answer
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
What is the status code in stored procedure transformation?
How you load distinct records into one target and duplicate records into another target?
Can you copy the batches?
How to load the data from people soft hrm to people soft erm using informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to generate sequence numbers using expression transformation?
Why filter transformation is an active one?
What is the difference between unicode & ascii mode data movement in informatica?
what is index?how it can work in informatica
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?