Answer / chanakya

SELECT CITY,
SUM(DECODE(GENDER,'MALE',NO)) MALE ,
SUM(DECODE(GENDER,'FEMALE',NO)) FEMALE
FROM TABLE_NAME GROUP BY CITY

Answer / venky

select city,sum(c1) male,sum(c2) female from(select
city,decode(gender,'male',no,0)
c1,decode(gender,'female',no,0) c2 from tablename) tablename
group by city;

Answer / sudheer

Select ABC.CITY AS CITY, sum(ABC.male) as MALE, sum(ABC.Female) as FEMALE from

(
select city, Sum(no) as male, NULL AS female from table_name
where gender = 'male'
Group by city

UNION

select city, NULL as male, SUM(no) AS female from table_name
where gender = 'female'
Group by city

) ABC Group by CITY

Answer / anshita gupta

select * from city pivot(max(no) for gender in('male ','female'));

Answer / venu

select* from tablename

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

When the informatica server marks that a batch is failed?

1 Answers  

what is galaxy repository?

2 Answers  

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

what is casual dimension?

6 Answers   IBM,

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

what is mystery dimension?

1 Answers  

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,