Interested to Buy Any Domain ? << Click Here >> for more details...
Filter transformation in the condition one of the data is NULL would the record be dropped.
- 2 Answers
- 5244 Views
- I also Faced
- E-Mail Answers
Answer Posted / sameer
Yes we write in filter conditions iif (isnull (cid),false,true) or using is_spaces function in there filter transformation and we can dropped the null records
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of caches in lookup?
Parameter and variable differences
where to store informatica rejected data? How to extract the informatica rejected data?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
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 .
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How can a transformation be made reusable?
explain one complex mapping with logic? sales project?
How to update a particular record in target with out running whole workflow?
Explain the pipeline partition with real time example?
What is update strategy transform?
What are the uses of etl tools?
How do you load alternate records into different tables through mapping flow?
Is stop and abort are same in informatica?
What are mapplets?
