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

what is INFORMATICA TESTING process

2242


Can u generate reports in Informatica?

1035


Explain in detail scd type 2 through mapping.

999


Design a mapping to load the cumulative sum of salaries of employees into target table?

1436


How to go to the older version for a mapping?

1038


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1027


if we have a delimiters at unwanted places in a flat file how can we over come those.

1998


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2135


Explain sessions?

996


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1597


I have a flat file, want to reverse the contents of the flat file

1073


Have you worked with/created Parameter file

1625


Explain the tuning lookup transformation - informatica

958


What does refresh system mean, and what are its distinctive choice?

1095


Implementation methodology

1659