Answer Posted / srinivas
there are four types of joins in Informatica
1) Normal join -- Equi join
2) Master join -- Left outer join
3) Detail join -- Right outer join
4) Full outer join -- Full outer join
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
Mention some types of transformation?
What is domain in terms of informatica?
What is intricate mapping?
How can we use mapping variables in informatica?
According to his methodology what all you need before you build a datawarehouse
Write the prerequisite tasks to achieve the session partition?
Why is sorter an active transformation?
How to use procedural logic inside infromatica?
What is mapping debugger?
What is the difference between informatica 7.0 and 8.0?
How to extract sap data using informatica?
how we can load rejected record's at run time?(not through bad files)
Explain the mapping variable usage example in informatica
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
