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 / kishore

We can use union all Transforamtion .if the struture is
same....

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate sequence numbers using expression transformation?

647


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2299


What are the main issues while working with flat files as source and as targets ?

658


Write the different tools in the workflow manager?

577


What are active transformations.

1191






In development project what is the process to follow for an etl developer from day1

1286


How many transformations can be used in mapplets.

1464


Enlist the tasks for which source qualifier transformation is used.

593


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1771


What is dimensional table?

625


How do you migrate data from one environment to another?

650


Why update strategy and union transformations are active?

594


Where do we use mapping variables in informatica?

619


Can you use flat files in Mapplets.

2226


Explian the Process of deployment groups in informatica

659