Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

Explain Dataware house architecture .how data flow from intial to end?

2580


How to create Target definition for flat files?

1215


How do you handle two sessions in Informatica

1154


How to improve the performance of a session using sorter transformation?

1144


waht type of interface is used for testing the data in informatica

2253


What are the guidelines to be followed while using union transformation?

1137


What is data movement mode in Informatica and difference between them?

1131


Differentiate between router and filter transformation?

1009


What all join we can perform in LOOKUP transformation?

966


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2393


What are the prerequisite tasks to achieve the session partition?

1250


What are the different types of transformation available in informatica.

1102


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1198


How to generate sequence numbers?

1082


Which transformation should we use to normalise the COBOL and relational sources?

1202