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
During the running session, output files are created by informatica server. Enlist few of them.
How does a rank transform differ from aggregator transform functions max and min?
What is data caches/ index caches?
What is workflow manager?
what is the difference between informatica6.1 and infomatica7.1
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is informatica worklet?
Differentiate between source qualifier and filter transformation?
What is a passive transformation?
Define pmcmd command?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain the features of connected and unconnected lookup.
What is rank transformation in informatica
Explain what are the different types of transformation available in informatica.