1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

can we use self join in informaitca?

Question Posted / bharathi

Answers were Sorted based on User's Feedback



can we use self join in informaitca?..

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

can we use self join in informaitca?..

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

can we use self join in informaitca?..

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

Post New Answer

More Informatica Interview Questions

How many cubes create from a single model?

1 Answers  

What are the types of maping in Getting Started Wizard?

1 Answers  

Where can we find the throughput option in informatica?

0 Answers  

What are the basic needs to join two sources in a source qualifier?

3 Answers  

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,




i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

what is flat file override?

1 Answers   Cap Gemini, HP,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

What are the restrictions of union transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories