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?

Answers were Sorted based on User's Feedback



how to join the two flatfiles using the joiner t/r if there is no matching port?..

Answer / sudhar

Connect the source Qualifier of two different flat files to
two different Exp Trans. Create a dummy output port in both
the exp trans. then using that port connect the joiner
Tansformation

Is This Answer Correct ?    13 Yes 1 No

how to join the two flatfiles using the joiner t/r if there is no matching port?..

Answer / jana

yes you can join two flatfiles using the joiner t/r even if
you don't have any matching port for that you need to take
one dummy column in source files and based on the dummy
column you can join them

Is This Answer Correct ?    6 Yes 0 No

how to join the two flatfiles using the joiner t/r if there is no matching port?..

Answer / alisha

Hi Sudhar

What condition we need to give in Joiner transformation to
join tht dummy column.

Is This Answer Correct ?    4 Yes 0 No

how to join the two flatfiles using the joiner t/r if there is no matching port?..

Answer / 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

how to join the two flatfiles using the joiner t/r if there is no matching port?..

Answer / vaas

Hi Jana,

How can we take a dummy column i.e what r the values would
be in that port? We need to take dummy columns on both files?

could u explain clearly. mi id is vaas31@yahoo.in

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is the difference between a router and a filter transformation?

1 Answers   TCS,


What is synonym?

2 Answers   Patni,


What is source qualifier transformation?

1 Answers  


how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,


Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,


how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,


List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  


write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,


What is confirmed dimension?

3 Answers  


what is mapping parameter?

2 Answers   Cap Gemini,


Categories