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 |
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Can you use one mapping to populate two tables in different schemas
what are the limitations of pushdown optimization technique ? Advance thanks
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
When do you use mapping parameters? (In which transformations)
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
Where do you create/define mapping parameter and mapping variable?
can anyone suggest best free Talend data integration training online
What is active and passive transformation?
what is the gap analysis?
What are the types of maping in Getting Started Wizard?
what is diff b/t sorter t/r and agg have the option sorter property...