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 two flat files in informatica?

Answers were Sorted based on User's Feedback



how to join two flat files in informatica?..

Answer / venkateshmalneni

If the structure of the two flat files is same we can use SQ.by using in direct


if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this


src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->

Is This Answer Correct ?    10 Yes 0 No

how to join two flat files in informatica?..

Answer / gangam rajesh

using joiner transformation

Is This Answer Correct ?    7 Yes 0 No

how to join two flat files in informatica?..

Answer / mehul thakur

Hi Rajesh
could you plz tell me the steps to join from joiner tr.

Regards
Mehul Thakur

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,


Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  


How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  


how to insert header after each group.

1 Answers   IBM,


How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  


Where do you create/define mapping parameter and mapping variable?

1 Answers  


What is operational data source (ODS)?

7 Answers  


i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


How do you use reject loader.

0 Answers  


What is exclusive and normal mode for repository services?

0 Answers  


Categories