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

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,


write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,


what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,


What are data-driven sessions?

0 Answers  


What are the out put files that the informatica server creates during the session running?

2 Answers  


In which transformation you cannot drag ports into it?

0 Answers   Informatica,


How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,


What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,


a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,


How mapping parameter and variable works

1 Answers  


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

7 Answers   CSC,


Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,


Categories