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
- 5276 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / isha
Use ISNULL function to guide filter to handle null values.
NULL will return 0 and row will be dropped
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is the way to execute pl/sql script using informatica mapping?
what is diff between grep and find
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Why we select the table which has minimum number of records as Master table in joiner?
What is the sequence generator transformation in informatica?
Teradata 
