Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to do the error handling of if ur source is flatfiles?
How will the document be delivered to me?
tell me the rules and responsblites in our project(my project is development)
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What do think which one is the better joiner or look up?
Explain pmcmd command usage in informatica
What is a snowflake schema?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can you increase the performance in joiner transformation?
Why is sorter an active transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
How to call shell scripts from informatica?
How can we remove the duplicates from flat file source?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
