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

how to join the 2 different table with different columns in
informatica?

Answer Posted / reni

Create one dummy record for each table:
from 2 source qualifiers connect a expression
transformation to create a output port as "Dummy" & assign
the value "1" to that port.
Then in joiner join based on this dummy port of two
different source.

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain one complex mapping with logic? sales project?

6656


How to do unit testing in informatica?

1165


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10675


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1102


How does a rank transform differ from aggregator transform functions max and min?

1194


What is the benefit of partitioning a session?

1171


Which are the different editions of informatica powercenter that are available?

1030


is it possible to index the data in cache of lkp transformation ?

2024


What are active transformations.

1647


Explain pushdown optimization and types in informatica

1065


How do you set a varible in incremental aggregation

1880


What are the tasks that can be performed using sq?

1086


What is data transformation manager process?

1149


How to extract sap data using informatica?

1039


Enlist the advantages of informatica.

1061