Filter transformation in the condition one of the data is NULL would the record be dropped.
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
Explain Dataware house architecture .how data flow from intial to end?
How to create Target definition for flat files?
How do you handle two sessions in Informatica
How to improve the performance of a session using sorter transformation?
waht type of interface is used for testing the data in informatica
What are the guidelines to be followed while using union transformation?
What is data movement mode in Informatica and difference between them?
Differentiate between router and filter transformation?
What all join we can perform in LOOKUP transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the prerequisite tasks to achieve the session partition?
What are the different types of transformation available in informatica.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to generate sequence numbers?
Which transformation should we use to normalise the COBOL and relational sources?