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

If the structure of 100 tables and the target table are
same then what is the use of joiner??

Here you need to do a Union.


If the structure of 100 tables and the target table are not
same then joiner should be used.
That means you will be picking up the desired Attributes
(columns) from these 100 tables and populating into the
target.

Please let me know your question clearly.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the way to execute pl/sql script using informatica mapping?

1506


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1014


In informatics server which files are created during the session rums?

1060


update strategy transformation in informatica

1012


Describe data concatenation?

1004


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?

1873


what is the hint? how to use it to reduce the query processing in program?

7622


tell me 5 session failure in real time how can you solve that in your project?

2181


how tokens will generate?

2152


What do you mean by blocking transformation?

968


Difference between Data and Index Caches?

1090


What are the restrictions of union transformation?

976


What are the data movement modes in informatica?

1078


What is event and what are the tasks related to it?

1051


Can you use flat files in Mapplets.

2609