DSXchange

where is the concept of vertical pivot.sorry i coulnt get ur solution....can u tell with proceure

where is the concept of vertical pivot.sorry i coulnt get ur solution....can u tell with proceure

can u reply elaborately

Input:

This is the input

No Name
1 Raghava
1 Rajiv
1 Ram
2 Suresh
2 Goutham
3 Vamsee
4 Bhima



Output

I should get this output


No Name
1 Raghava,Rajiv,Ram
2 Suresh,goutham
3 Vamsee
4 Bhima

how to increase the performance of a job in server.....is there ant techniques for performance tunning

can we get 5 records in the target,if there is one record in the source and hash file which is used as lookup has 5 records with a same key.

is it possible without unix,aggregater and sort

can we do this without using sort stage.

rrsivaraghava wrote:can u plz tell the detail stage variable for this

if it has to be done then it should be sorted or not necessary

can u plz tell the detail stage variable for this

not the row number.i want the count of project for that project manager.suppose projectmanager1 has 4 projects then the count should be 4.if we has two projects then count should be 2

Hi, IS there any way in datastage to count group by columns..suppose for example one project manager have 4 projects and the other have two projects.then we like to have the count of projects of each project manager projects.let name of project manager is one column and list of projects is another ...

Hi, IS there any way in datastage to count group by columns..suppose for example one project manager have 4 projects and the other have two projects.then we like to have the count of projects of each project manager projects.let name of project manager is one column and list of projects is another c...