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

What is meant by pre and post session shell command?

1121


While migrating the data from one environment to another environment how would you manage the connections?

1059


What are the features of complex mapping?

1114


Explain sessions and how many types of sessions are there?

971


What is informatica worklet?

1001


How does the aggregator transformation handle null values?

1107


Explain constraint based loading in informatica

1057


Explain the different lookup methods used in informatica?

990


How to create the source and target database connections in server manager?

1054


What does cheating measurement mean?

1009


What all are steps in up gradation of Informatica server?

1012


What is mapping debugger?

966


How to do unit testing in informatica? How to load data in informatica ?

1063


How can you increase the performance in joiner transformation?

1155


When do you use sql override in a lookup transformation?

1045