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 / raja
we use the union transformation,but metadata must be same
then it is possible to join the two hetrogenous tables
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the use of code page?
Performance tuning in UNIX for informatica mappings?
Global and Local shortcuts. Advantages.
Briefly explain the aggregator transformation?
How many numbers of sessions can one group in batches?
Which version configuration tool used in ur project?
How identifying bottlenecks in various components of informatica and resolving them?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
difference between repository database and repository service?
What is enterprise data warehousing?
What do you mean by blocking transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
how we can load rejected record's at run time?(not through bad files)
explain abt ur project architecture?
Explain why we use partitioning the session in informatica?