Interested to Buy Any Domain ? << Click Here >> for more details...
Filter transformation in the condition one of the data is NULL would the record be dropped.
- 2 Answers
- 5360 Views
- I also Faced
- E-Mail Answers
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
Define the various join types of joiner transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Define Pmrep command?
What the difference is between a database, a data warehouse and a data mart?
How to handle decimal places while importing a flatfile into informatica?
How is union transformation utilized?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What you know about transaction control transformation?
Write the unconnected lookup syntax?
Define sessions in informatica etl?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Different sorts of metadata that stores in the storage facility?
How can a transformation be made reusable?
