Filter transformation in the condition one of the data is NULL would the record be dropped.
Answer Posted / sameer
Yes we write in filter conditions iif (isnull (cid),false,true) or using is_spaces function in there filter transformation and we can dropped the null records
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
tell me about your project functionality
Which transformation should we use to normalise the COBOL and relational sources?
How to load the data from people soft hrm to people soft erm using informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Differentiate between Load Manager and DTM?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain the mapping variable usage example in informatica
Briefly define reusable transformation?
what is Active lock explain
How big was your fact table
How to create or import flat file definition in to the warehouse designer?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to delete duplicate row using informatica?
What are batches?
What is decode in informatica?