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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / dada

Answer Posted / dada

Hi Guys,

We can use union transformation to join 100 tables.but the
thing is it should be same structure.by using one union we
can do it. for ex all 100 tables have same order,datatype
(std_name,loc,dept) then only we can do it by union.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you take back up of repository?

1162

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1081

What are the advantages of using informatica as an etl tool over teradata?

1023

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?

6493

What is the difference between informatics 7x and 8x and what is latest version?

1085

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7456

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1133

Is there any way to read the ms excel datas directly into informatica?

1022

Explain what are the different versions of informatica?

1100

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

2038

what is informatica metadata?

1043

Explain the difference between mapping parameter and mapping variable?

1042

How an expression transformation differs from aggregator transformation?

1044

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2163

Explain lookup transformation is active in informatica

1108