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?
Answers were Sorted based on User's Feedback
Answer / kishore
We can use union all Transforamtion .if the struture is
same....
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
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.
Is This Answer Correct ? | 15 Yes | 11 No |
Answer / ik
its possible by using 2 different sessions and connecting them in a single workflow
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anoymous
Not possible to join flat file without transformations
however relational sources can be joined in source qualifier
ex: select * from emp,dept;
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 1 No |
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.
Is This Answer Correct ? | 1 Yes | 3 No |
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.
Is This Answer Correct ? | 3 Yes | 6 No |
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
Is This Answer Correct ? | 3 Yes | 10 No |
What are the guidelines to be followed while using union transformation?
If u r using dynamic cache lookup port will be thier in thet which option u will select
in realtime which situations u can use unconnected lookup transformation
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What happens when a session fails and you click on recover?
Which transformation is needed while using the Cobol sources as source definitions?
What is Cognos script editor?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
How is union transformation utilized?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the different components of powercenter?