How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / charan
Hi,
I know this is possible but not sure how.. SQ is used for
Homogenius sources. Anyone else please try to get a
positive answer on this one.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Could you explain what is enterprise data warehouse?
What are the prerequisite tasks to achieve the session partition?
Explain the different dimensions.
What are the advantages of informatica?
How will the document be delivered to me?
How many numbers of sessions can one group in batches?
Is it possible to revert a global repository to local one and why?
Repository user profiles
How many ways are there to do 'remove duplicate records in informatica'?
Explain the informatica workflow?
What does reusable transformation mean?
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
What is the need of an ETL tool?
Explain sessions. Explain how batches are used to combine executions?
Performance tuning in UNIX for informatica mappings?