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 |
How to extract sap data using informatica? What is abap? What are idocs?
What is data transformation manager process?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
Howmany ways yoU can update a relational source defintion and what are they?
What are the phases in SDLC?
any body can say about all versions of informatica ?how many versions ?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
How do you change a non-reusable transformation to reusable transformation?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,