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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain what are the different types of transformation available in informatica.
Define pmcmd command?
What is sq transformation?
What are the static cache and dynamic cache in informatica?
Which are the different editions of informatica powercenter that are available?
What are the components of the workflow manager?
tell me 5 session failure in real time how can you solve that in your project?
Explain about cumulative Sum or moving sum?
What is the session task and command task?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Does an informatica transformation support only aggregate expressions?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
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
What is meant by pre and post session shell command?
