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
What is rank transform?
waht type of interface is used for testing the data in informatica
Performance tuning in UNIX for informatica mappings?
What is the different lookup cache(s)?
What is confirmed fact in dataware housing?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is rank index in rank transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Informatica Checkpoints
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the new features of informatica 9.x at the developer level?
What is enterprise data warehousing?
What is meant by query override?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Scheduling properties,whats the default (sequential)