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
What is the need of an ETL tool?
Is there any way to read the ms excel datas directly into informatica?
Have you worked with/created Parameter file
What are the different lookup cache(s)?
What is incremental aggregation?
What is sequence generator transformation in informatica?
-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?
what is size of u r database?
How can repository reports be accessed without sql or other transformations?
difference between repository database and repository service?
Please let me know how to make encryption and decryption with example?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How can we use mapping variables in informatica?
difference between informatica 8.1.1 and 8.6