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

Answer Posted / pushparao

joiner transformation is used for combining the columns of the
different tables with common column horizontally with respect
to data of the columns.
union transformation is used to combined data for the common
columns.
or
simply joiner transformation-->Horizontal collection of the
columns.
union transformation-->vertical collection of rows.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about Informatica server process that how it works relates to mapping variables?

1047

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2011

How to differentiate between the active and passive transformations?

1137

What is the meaning of decode in informatica?

1107

explain abt ur project architecture?

2169

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?

6445

Different sorts of metadata that stores in the storage facility?

994

What is the Rank index port in Rank transformation?

1044

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1651

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1995

How to extract sap data using informatica?

1026

What do you understand by SOA of Informatica?

963

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1886

What is intricate mapping?

1173

What is target designer and target load order?

1089