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.
- 2 Answers
- 5382 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
can we see default group,when we use router?if yes how?
why we are using level option in normalizer transformation
What is the difference between normal and bulk loading? Which one is recommended?
can we use bulk loading when we use look in mapping
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What is transformation?
Define sessions in informatica etl?
Explain what is informatica metadata and where is it stored?
Which gives the more performance when compare to fixed width and delimited file ? and why?
what is mapping performence?
difference between repository database and repository service?
Teradata 
