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

What is sequence generator transformation in informatica?

0 Answers  

How are parameters defined in informatica?

3 Answers   HP, TCS,

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

in performance wise union is past,union all is past

2 Answers  

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

Explain grouped cross tab?

1 Answers   Accenture,

Please let me know how to make Data masking in informatica..

0 Answers  

what is target update override and when we use it?

2 Answers   TCS,

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

what is the incremental agrrigation?

2 Answers   Cap Gemini,

What are the new features in Informatica 5.0?

1 Answers