Filter transformation in the condition one of the data is NULL would the record be dropped.
- 2 Answers
- 4392 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 |
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the informatica performance improvement tips
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
Normalizer transformation is not involved in Mapplet.. why???
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
What is update strategy transform?
How to call shell scripts from informatica?
How to import oracle sequence into Informatica?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
How many ways are there to do 'remove duplicate records in informatica'?
EXL informatica Questions
What is a repository manager?
Teradata 
