can we use self join in informaitca?
- 3 Answers
- 19776 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran ghatage
You can go through the following solution from Informatica Marketplace. You will also find over 400 mapping samples and many other useful tools on the same website.https://community.informatica.com/solutions/developer_client_self_join_using_joiner
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
Yes we can use self join informatica using SQL override..
and remember Joiner transformation does not support for self
join..
| Is This Answer Correct ? | 5 Yes | 6 No |
Answer / 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 |
Mention some types of transformation?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
tell me about your project functionality
Global and Local shortcuts. Advantages.
why we use materialized view over view?
What do you mean by channel change?
What are the reusable transforamtions?
What are the different versions of informatica?
How do you handle decimal places while importing a flatfile into informatica?
What is the command used to run a batch?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Teradata 
