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

write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000

Answer Posted / vikram

Hey are you guys not informatica resource.. why do you post
answer when you dont know answer.

I have seen this question on many pages and ans give as
Normalizer.

Guys: Correct answer is to use Aggregator..

Normalize : converts rows to column
Agg : Can convert columns to row

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1306


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

1171


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2248


According to his methodology what all you need before you build a datawarehouse

1801


What happens when a session fails and you click on recover?

1172


Which are the different editions of informatica powercenter that are available?

1079


Can u generate reports in Informatica?

1143


Explain target update override in informatica

1190


How to do unit testing in informatica? How to load data in informatica ?

1184


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1327


Why filter transformation is an active one?

1033


How we can create indexes after completing the loan process?

1251


How to do the error handling of if ur source is flatfiles?

2017


How to configure mapping in informatica?

1223


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2402