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 row to column follwing source?

quarter sales
q1 5000
q1 9000
q1 7000
q1 6000
q2 5000
q2 4000
q2 3000
q2 1000
q3 4000
q3 3000
q3 1000
q3 2000
q4 5000
q4 400
i want the output?
q1 q2 q3 q4
sales

Answer Posted / senthil kumar s

It wouldn't work many to one concept for Normalizer.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the informatica workflow?

1127


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1316


What is resilience time?

1227


Different circumstance which drives informatica server to expel records?

1043


What is a node in Informatica?

1087


Write the unconnected lookup syntax and how to return more than one column.

1150


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1958


What are the steps involved in the migration from older version to newer version of Informatica Server?

2153


can you please explain me pre session and post session options?

7678


What is the difference between informatics 7x and 8x and what is latest version?

1138


What is Index Caches size?

1165


What is the sql query overwrite in source qualifier in informatica

1142


What are the new features of Power Center 5.0?

1849


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4253


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8266