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


Please Help Members By Posting Answers For Below Questions

What is the use of code page?

608


Performance tuning in UNIX for informatica mappings?

2145


Global and Local shortcuts. Advantages.

1470


Briefly explain the aggregator transformation?

599


How many numbers of sessions can one group in batches?

623






Which version configuration tool used in ur project?

2770


How identifying bottlenecks in various components of informatica and resolving them?

586


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

1411


difference between repository database and repository service?

624


What is enterprise data warehousing?

615


What do you mean by blocking transformation?

585


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.

1855


how we can load rejected record's at run time?(not through bad files)

1910


explain abt ur project architecture?

1765


Explain why we use partitioning the session in informatica?

617