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
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the main features of Oracle 8i with context to datawarehouse?
How to load last n records of file into target table - informatica
What is fact table? Explain the different kinds of facts.
How to generate or load values in to the target table based on a column value using informatica etl tool.
tell me the rules and responsblites in our project(my project is development)
What is the reusable transformation?
What are the differences between oltp and olap?
Make a note of the quantity vaults made in informatica?
If informatica has its scheduler why using third party scheduler?
Explain pmcmd command usage in informatica
What do you mean by filter transformation?
What does update strategy mean, and what are the different option of it?
What is joiner change?
Explain the different dimensions.