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

use Normalized transformation in the mapping.we get result.








Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various types of transformation?

1157


How is union transformation utilized?

995


Do you find any difficulty while working with flat files as source and target?

1080


Explain the types of transformations?

1049


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

2393


Is there any target staging area in informatica not staging area

2553


What is the difference between stop and abort in informatica

1069


What is a router transformation?

1100


What are the uses of etl tools?

1109


The question was on time stamp. what is the difference between HH and HH24 when to use when.

2038


What is Cognos script editor?

4206


What are pre and post-session shell commands?

1283


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?

1228


What are active and passive transformations?

1068


What is informatica? Why do we need it?

1080