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 / bsgsr

after reading the above answers i find one is left joining
the tables in the database itself rather than joinng them
in the session using 99 joiners. it would also increase
performance.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of look up transformation?

1125


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2122


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10688


have u done any performance tuning? how u ll do?

2299


Why do you use Mapping Parameter and mapping variable?

1770


What is session task and command task?

1303


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1947


How might one distinguish in the case of mapping is right or not without associating session?

1129


What is a standalone command task?

1209


What is dimensional table? Explain the different dimensions.

1174


What is the difference between STOP and ABORT options in Workflow Monitor?

1258


Why filter transformation is an active one?

988


What is resilience time?

1149


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7250