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 / gopi krishna k

Answer Posted / gopi krishna k

write a pre sql which joins all 100 tables
Am I right?

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is decode in informatica?

1166

Slowly changing dimensions, types and where will you use them

1717

write a query to retrieve the latest records from the table sorted by version(scd)

1069

Describe data concatenation?

1085

What is meant by pre and post session shell command?

1161

What is informatica? Why do we need it?

1104

What is InformaticaPowerCenter?

1138

Under which circumstances, informatica server creates reject files?

1098

Where are the source flat files kept before running the session?

1084

what is $$$$?

2163

Parameter and variable differences

2063

How to implement security measures using repository manager?

1182

Make a note of the quantity vaults made in informatica?

988

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1087

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 .

1946