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 different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task

Answer Posted / tauseef

hai Taueef

As per above requirement my suggestion is
if the sources having similar columns then we go with union

if there is no similar columns add dummy port on all d source and use joiner transformation

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create or import flat file definition in to the warehouse designer?

1018


What is meant by LDAP users?

1107


Different sorts of metadata that stores in the storage facility?

945


What are the performance considerations when working with aggregator transformation?

1094


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1263


Explain the mapping variable usage example in informatica

1079


What is a snowflake schema?

918


Can anyone tell me the new features in Informatica 9 Version?

2030


How can we handle two sessions in informatica?

978


how many types of dimensions are available in informatica?

994


What could be the possible resons of locks by user?

1032


Can informatica load heterogeneous targets from heterogeneous sources?

1112


What does reusable transformation mean?

1066


How do you promote a non-reusable transformation to reusable transformation?

1066


What is an expression transformation in informatica?

958