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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank transform?

1002


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

2259


Performance tuning in UNIX for informatica mappings?

2571


What is the different lookup cache(s)?

1092


What is confirmed fact in dataware housing?

6977


Can we change Dynamic to Static or Persistent cache? If so what happens?

2214


What is rank index in rank transformation?

1082


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2064


 Informatica Checkpoints

3334


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1093


What are the new features of informatica 9.x at the developer level?

1047


What is enterprise data warehousing?

1052


What is meant by query override?

1061


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7188


Scheduling properties,whats the default (sequential)

1963