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...

i have two sources two flatfiles same structure
one flatfile contain 100 million recs
another flatfile contain 10 million recs
i have to connect single target(performance oriented answer)
what are the steps we have to do this scenario

Answer Posted / babu

Hi Teja,
The two sources are haveing same structure,so beter to
use list file,to load the data into single TARGET.

Procedure:
----------
1.Place the two source paths in a note pad and
save as it '.list' format.
2.create a maping as per your requirement in
that mapping you have to take only one source no need to
take two sources.
3. Create a session and workflow.
4.In session give a SOURCE FILE PATH
is '.list' file and SOURCE FILE TYPEA as INDIRECT.

Let me know if any thing wrong.

Thanks,
dwarak.vbr@gmail.com

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why update strategy and union transformations are active? Explain with examples.

1241


Briefly explain the aggregator transformation?

1010


What are the types of caches in lookup?

1050


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2037


How to extract sap data using informatica? What is abap? What are idocs?

1182


Mention few advantages of router transformation over filter transformation.

1023


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1921


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066


What is a filter transformation and why it is an active one?

969


How to load the data from a flat file into the target where the source flat file name changes daily?

1063


explain about unit testing? in real time?

2205


The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057


Explain transaction control transformation in informatica

1268


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2172


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979