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

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

Explain the features of connected and unconnected lookup.

0 Answers  

what is parallel querying and what r hints.

1 Answers  

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

What is a data modeling?

2 Answers