Answer Posted / ankit kansal
However joiner Trans does not support self join , but you can achieve similar functionality with the following steps.
1) create two expression transformation and input them using Source Qualifier.
2) Pull joiner transformation and join both two expression transformation using keys like mgrno = empno
3)NOTE:- check sorted input box and pull your data as ordered.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
To import the flat file definition into the designer where should the flat file be placed?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Is it possible to create multiple domains on a single Informatica server?
How to load a Dimension ? and how to load a fact table?
Define filter transformation?
What are active and passive transformations?
What are different types of transformations available in informatica?
draw informatica architecture 8.6 ?
Mention some types of transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Mention a few design and development best practices for informatica?
How many ways are there to create ports?
What are mapplets? How is it different from a Reusable Transformation?
What is an aggregator transformation?