can we use self join in informaitca?
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 power play plug in?
Can you use one mapping to populate two tables in different schemas
What did you do in source pre load stored procedure
what is a time dimension? give an example?
explain about lookup t/r?
Write the unconnected lookup syntax and how to return more than one column.
What is confirmed fact in dataware housing?
What is up date strategy and what are the options for update strategy?
What is fact table? Explain the different kinds of facts.
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Which gives the more performance when compare to fixed width and delimited file ? and why?