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
differences between service based and product based?
What is a predefined event?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can we create two repositories on same database instance in oracle?
What are the different types of transformation available in informatica.
what is SDLC way of code development?
Explain the different dimensions.
Clarify the utilization of aggregator cache record?
How many input parameters can exist in an unconnected lookup?
What is a filter transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to elaborate powercenter integration service?
What is target load order?
What is pmcmd command?
how tokens will generate?
