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?
- 10 Answers
- 23377 Views
- Wipro, I also Faced
- E-Mail Answers
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 is the difference between stop and abort in informatica
What are the options in the target session of update strategy transsformatioin?
How do we call shell scripts from informatica?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
What is the term PIPELINE in informatica ?
explain abt joiner t/r?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
How to improve the performance of Aggregate transformation?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
Teradata 
