Filter transformation in the condition one of the data is NULL would the record be dropped.
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 do u tune queries?
What do you understand by a term domain?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is hash partition?
How many repositories can be created in informatica?
Differentiate between router and filter transformation?
what is bitmap index? did u use it?and how to use it in informatica
what is worklet and what use of worklet and in which situation we can use it?
What is the difference between Bulk Load and Normal Load
What is a filter transformation?
without update strategy how to insert &update?