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

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?

Answer Posted / mubbasir

This can be done by passing all ports to an expression
transformation and then creating a output port say ID=1 in
both the expression transformation of each file and then
join it using a joiner on ID,hope this helps..

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by lookup transformation? Explain the types of lookup transformation?

1020


What is a router transformation?

1212


Enlist the tasks for which source qualifier transformation is used.

1075


can u any challenge your project?

2084


What is joiner transformation?

1067


What is the procedure for creating independent data marts from informatica 7.1?

1118


Can you generate sequence numbers without using the sequence generator transformation?

1162


How to Create a folder using pmrep command?

1222


What if the source is a flat-file?

1168


What is the difference between informatics 7x and 8x and what is latest version?

1137


What are connected or unconnected transformations?

1172


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2199


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2082


What does cheating measurement mean?

1106


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1646