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
How can we handle two sessions in informatica?
What is the benefit of session partitioning?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are data-driven sessions?
What is the difference between a repository server and a powerhouse?
What is lookup change?
What is flashback table ? Advance thanks
Explain the different lookup methods used in informatica?
State the differences between sql override and lookup override?
Enlist the advantages of informatica.
What is a transaction control transformation?
What does update strategy mean, and what are the different option of it?
what are the deliverables?in your project?
Describe the impact of several join conditions and join order in a joiner transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?