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
What are the steps involved in the migration from older version to newer version of Informatica Server?
How might one distinguish in the case of mapping is right or not without associating session?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
In how many ways we can create ports?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a code page?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Please let me know how to make encryption and decryption with example?
What are the types of lookup transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
While migrating the data from one environment to another environment how would you manage the connections?
How to use pmcmd utility command?
what is INFORMATICA TESTING process
how to create user defined function (udf) in informatica