Answer / kishore

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

Answer / arjun

not possible

Answer / raja

we use the union transformation,but metadata must be same
then it is possible to join the two hetrogenous tables

Answer / aakansha

It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.

Answer / ik

its possible by using 2 different sessions and connecting them in a single workflow

Answer / anoymous

Not possible to join flat file without transformations
however relational sources can be joined in source qualifier

ex: select * from emp,dept;

Answer / rahul

no its not possible.

sql trans is used to connect hetro src but when you drag
flat file n connect to Sq t/r , all properties expect
tracing level evey thing will be disable.

SO WE CANT JOIN

Answer / abhishek upadhyay

Hi All,

Whatever you all have mentioned is true.....that the source
qualifier joins only homogenous tables and as per the
question we can not use a joiner.

But,
If it is a normal join we can do this by using lookup
transformation between those two files.......
In case of full outer or left outer or right outer joins
this will not work..Thanks a lot.

Answer / 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.

Answer / mallikarjun

Hi Ajith,
It is Possible to Join data from a flat file and a relation
source, this can be done with the help of a joiner
transformation where you have to map one input port to the
relation data column and other to the flat file coumn and
give the joiner condition.. Hope this will help you or drop
a mail...


Thanks & Regards,
Mallikarjun

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

Which development components of informatica have the highest usage?

0 Answers  

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

what is index?how it can work in informatica

0 Answers  

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

How to create the source and target database connections in server manager?

0 Answers   Informatica,

Can you copy the session to a different folder or repository?

2 Answers  

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

what is incremantal aggregation?

1 Answers  

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

Why do we use DSS database for OLAP tools?

2 Answers