Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 25413 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how many types of dimensions are available in informatica?
What are the different clients of powercenter?
What is joiner transformation?
If informatica has its scheduler why using third party scheduler?
What is a filter transformation and why it is an active one?
What the difference is between a database, a data warehouse and a data mart?
What is informatica powercenter repository?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the function of aggregator transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Did u used latest transformations of 8.6.0? for what?
Why update strategy and union transformations are active? Explain with examples.
How to use procedural logic inside infromatica?
Why do we need informatica?
Explain lookup transformation in informatica
