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

Hi,

Check with Normaliser Transformation
it will help you.


Any queries !! let me know
srinu.srinuvas@gmail.com

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an Integration service in Informatica?

1081


What is InformaticaPowerCenter?

1074


what is index?how it can work in informatica

1979


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2350


How can we use mapping variables in informatica? Where do we use them?

1099


What is main use of mapplet?

1070


How can you differentiate between powercenter and power map?

1018


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

1950


Which means the first record should come as last record and last record should come as first record and load into the target file?

1020


my source is junk data how will u remove that junk data by using unix please any one replay me

3649


What is xml source qualifier transformation in informatica?

1174


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1027


How can you generate reports in informatica?

972


What is dimensional table?

1002


How do you update the records with or without using update strategy?

1055