Filter transformation in the condition one of the data is NULL would the record be dropped.

Answers were Sorted based on User's Feedback



Filter transformation in the condition one of the data is NULL would the record be dropped...

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

Filter transformation in the condition one of the data is NULL would the record be dropped...

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

Post New Answer

More Informatica Interview Questions

Informatica and datawarehousing courses in Pune?

2 Answers  


In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,






What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


what is incremental data aggregation?

3 Answers   IBM,


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,


A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


Please let me know how to make encryption and decryption with example?

0 Answers  


Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,


what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,


Categories