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

HOw can we load the normalised data ( Vertical data) to
(Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. But,
what exactly I want is .. If we have million of records,it
is not possible using decode and search for that Particular
Id to pivot into Horizontal data... Can any one of guys
please help me in this regard.....

Answer Posted / friend

Use SQL Transformation for your process

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3810


What is different between the data warehouse and data mart?

998


Explain load alternative records / rows into multiple targets - informatica

1097


What is aggregator transformation in informatica?

895


What is meant by incremental aggregation?

1018


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

10629


What are the features of complex mapping?

1091


What are the mapping parameters and mapping variables?

1082


What is the need for an etl tool?

1009


what are the deliverables?in your project?

2084


How do you load alternate records into different tables through mapping flow?

1798


How do you take back up of repository?

1092


Enterprise data warehouse your projects phase by phase explain?

1854


What is standalone command task?

1256


How to configure mapping in informatica?

1116