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
Can we create a Integration service without a Repository service and vice versa?
Is it possible to define a single node as a Gateway node as well as worker node?
What is depict expression change?
What are the advantages of using informatica as an etl tool over teradata?
Explain lookup transformation is active in informatica
Explain the different dimensions.
Define pmcmd command?
Why filter transformation is an active one?
explain about unit testing? in real time?
What are the components of the workflow manager?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Does an informatica transformation support only aggregate expressions?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks