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 / amedela chandra sekhar

BY USING NORMALIZER T/R WE CAN ACHIEVE THIS SCENARIO.








I hope i have given right solution.

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Data Caches size?

1130


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1339


What is a node in Informatica?

1087


Write the different tools in the workflow manager?

1119


Write the prerequisite tasks to achieve the session partition?

1230


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 ?

2246


What are connected or unconnected transformations?

1174


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2126


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

1172


What are the differences between source qualifier and joiner transformation?

1137


What is a filter transformation?

1094


What is the way to execute pl/sql script using informatica mapping?

1681


complex mapping ur project u r invlve can u explain and give real time example give me ?

2352


On which transformations you created partitions in your project?

1436


What do you understand by a term domain?

1173