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 the need of an ETL tool?

1160


Is there any way to read the ms excel datas directly into informatica?

1069


Have you worked with/created Parameter file

1714


What are the different lookup cache(s)?

1167


What is incremental aggregation?

1137


What is sequence generator transformation in informatica?

1127


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5880


what is size of u r database?

2365


How can repository reports be accessed without sql or other transformations?

1268


difference between repository database and repository service?

1224


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

1950


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2512


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265


How can we use mapping variables in informatica?

1125


difference between informatica 8.1.1 and 8.6

3732