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 to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the advantages of using informatica as an etl tool over teradata?
What is repository manager?
Explain sessions. Explain how batches are used to combine executions?
How can you validate all mappings in the repository simultaneously?
How to load the data from people soft hrm to people soft erm using informatica?
What are the different types of transformation available in informatica.
How to use procedural logic inside infromatica?
What is a sequence generator transformation?
What is meant by incremental aggregation?
What are some examples of informatica etl programs?
What is exclusive and normal mode for repository services?
Explain what is informatica metadata and where is it stored?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is rank index in rank transformation?