Interested to Buy Any Domain ? << Click Here >> for more details...
can we use self join in informaitca?
- 3 Answers
- 19393 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 |
What is the Rank index port in Rank transformation?
Can we combine a flatfile and a database table using an UNION transformation?
How an expression transformation differs from aggregator transformation?
How will you convert rows into columns or columns into rows
in performance wise union is past,union all is past
Explain in detail scd type 2 through mapping.
What is an Integration service in Informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
What are the differences between a connected lookup and unconnected lookup?
What are the circumstances that infromatica server results an unreciverable session?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
Teradata 
