Yes, I am keeping the last row in the Remove Duplicates stage...
But the o/p i am getting is:
1, HariRaj (Here Ram is missing)
2,JohnterrySmithPeter
Search found 7 matches
- Fri Apr 11, 2014 10:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenate multirow data into one line
- Replies: 8
- Views: 3052
- Fri Apr 11, 2014 9:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenate multirow data into one line
- Replies: 8
- Views: 3052
I tried the below method in 9.1.. SRC-->SORT-->TFM-->Remove Duplicate--> TGT Sort by class and in TFM, I am taking 3 stage variables as below order KeyNext=class concatText= If keyNext <> keyPre Then STUDENTS else concatText: STUDENTS keyPre=KeyNext Here I am getting partial o/p as the first row dat...
- Fri Apr 11, 2014 4:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenate multirow data into one line
- Replies: 8
- Views: 3052
Concatenate multirow data into one line
Hi, input file: CLASS, STUDENTS -------------------------- 1,Ram 1,Hari 1,Raj 2,John 2,terry 2,Smith 2,Peter O/p should be: CLASS, STUDENTS -------------------------- 1,RamHariRaj 2,JohnterrySmithPeter I wanted to concatenate all the rows based on the group column which is class here. Please suggest...
- Tue Mar 11, 2014 4:23 am
- Forum: General
- Topic: Failed to authenticate the current user against the selected
- Replies: 5
- Views: 4482
Failed to authenticate the current user against the selected
Hi, While I am trying to connect to Designer Client its showing me the error message " Failed to authenticate the current user against the selected Services Tier " but at the same time I am able to connect to Director Client. Trying to connect to DS through Windows 7 64-bit machine. Thanks...
- Thu Jun 06, 2013 3:32 am
- Forum: General
- Topic: Command to get list of uncompiled jobs
- Replies: 1
- Views: 2307
Command to get list of uncompiled jobs
Hi,
I wanted to fetch all the job names which are in non compiled state using UNIX command from particular category.
Can someone tell me the UNIX command to get all uncompiled jobs category-wise?
Regards,
Satya
I wanted to fetch all the job names which are in non compiled state using UNIX command from particular category.
Can someone tell me the UNIX command to get all uncompiled jobs category-wise?
Regards,
Satya
- Thu Feb 07, 2013 1:56 am
- Forum: General
- Topic: Installing DataStage client 7.1, 7.5.1 and 8.7 in Windows 7
- Replies: 3
- Views: 2995
- Wed Feb 06, 2013 1:43 pm
- Forum: General
- Topic: Installing DataStage client 7.1, 7.5.1 and 8.7 in Windows 7
- Replies: 3
- Views: 2995
Installing DataStage client 7.1, 7.5.1 and 8.7 in Windows 7
Hi,
Is it possible to install DS 7.1, 7.5.1 and 8.7 clients in one Windows 7 64-bit machine. If yes, then is there anything special needs to be done to make everything (7.1, 7.5.1 and 8.7) work fine without any issue using multi-client manager??
Is it possible to install DS 7.1, 7.5.1 and 8.7 clients in one Windows 7 64-bit machine. If yes, then is there anything special needs to be done to make everything (7.1, 7.5.1 and 8.7) work fine without any issue using multi-client manager??