Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

Difference between task flow and linear task flow

0 Answers  

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

what is the -ve test case in your project.

0 Answers   CTS, TCS,

What is main use of mapplet?

0 Answers  

What is deployment group?

0 Answers  

why we r using presql&postsql in source qualifier?

1 Answers   HP,

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

What are two types of processes that informatica runs the session?

2 Answers  

How the informatica server increases the session performance through partitioning the source?

1 Answers  

For more Informatica Interview Questions Click Here
Categories