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...

can we use self join in informaitca?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1225


What are the main features of Oracle 8i with context to datawarehouse?

2051


How to load last n records of file into target table - informatica

1018


What is fact table? Explain the different kinds of facts.

1010


How to generate or load values in to the target table based on a column value using informatica etl tool.

1016


tell me the rules and responsblites in our project(my project is development)

1874


What is the reusable transformation?

1006


What are the differences between oltp and olap?

920


Make a note of the quantity vaults made in informatica?

941


If informatica has its scheduler why using third party scheduler?

1192


Explain pmcmd command usage in informatica

1065


What do you mean by filter transformation?

902


What does update strategy mean, and what are the different option of it?

1034


What is joiner change?

1078


Explain the different dimensions.

912