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
Partition, what happens if the specified key range is shorter and longer
r u done any partitions in ur project?
Which transformation is needed while using the Cobol sources as source definitions?
Enlist the differences between database and data warehouse.
How does the aggregator transformation handle null values?
What is an active transformation?
Explain the use of aggregator cache file?
Mention some types of transformation?
Slowly changing dimensions, types and where will you use them
What are the restrictions of union transformation?
What are the measure objects?
How are indexes created after completing the load process?
Clarify the aggregator change?
COM components can be used in Informatica
What is rank index in rank transformation?