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

whatis the default data driven operation in informatica

2 Answers  


how i will stop my workflow after 10 errors

1 Answers   HP,


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,


What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,


In target table how to display the system time

1 Answers  


What are the mapping paramaters and mapping variables?

1 Answers  


What are the differences between source qualifier and joiner transformation?

0 Answers  


If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,


Kimball and Inmon methodologies?

2 Answers  


How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,


In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,


How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,


Categories