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 two flatfiles using the joiner t/r if there
is no matching port?

Answer Posted / vin

create dummy1 port in flat file1
create dummy2 port in flat file2

assign the value '1' to both dummy1 and dummy2.

In the lookup condition use dummy1=dummy2. This is going to be always true so all the records are took into consideration.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1009


what is unit testing?tell me proceedure

2164


wf dont have integration severances how you can run?

1883


scenario where i can use only concurrent execution of workflow.

3062


Write the unconnected lookup syntax?

1029


What the difference is between a database, a data warehouse and a data mart?

1080


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4676


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1715


what is song in infrmatica...?

2161


What is the use of transformation?

945


What is the session task and command task?

991


What is joiner transformation in informatica?

993


Performance tuning in UNIX for informatica mappings?

2506


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1133


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

1986