DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 32 matches
Author Message
 Topic: combine 5 records into one records
rakesh.puli

Replies: 8
Views: 1937

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 04, 2020 9:11 am   Subject: Re: combine 5 records into one records
Thank you for your reply Poorna.I will try this.


Hi Rakesh,

I found a solution to your query:
SRC--> Transformer --> TGT

In Transformer :
Stage Variables ->
svar1 : If IsNotNul ...
 Topic: combine 5 records into one records
rakesh.puli

Replies: 8
Views: 1937

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 26, 2020 10:35 am   Subject: combine 5 records into one records
Hi Chulett,

Thank you for your reply.

I tried using Lastrow() function, But my approach is not working. where exactly we have to use this LastRow() function in the derivation.
I tried solving t ...
 Topic: combine 5 records into one records
rakesh.puli

Replies: 8
Views: 1937

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 12, 2020 1:01 am   Subject: combine 5 records into one records
that's my mistake.yes its for all records.
 Topic: combine 5 records into one records
rakesh.puli

Replies: 8
Views: 1937

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 11, 2020 10:38 am   Subject: combine 5 records into one records
No. It should not be 4 output records. Suppose, If there are 20 records then output should be one record with one filed as (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)
 Topic: combine 5 records into one records
rakesh.puli

Replies: 8
Views: 1937

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 11, 2020 12:57 am   Subject: combine 5 records into one records
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Can any one please explain how to achieve this scenario in datastage using transformer?



Input

ColA
1
2
3
4
5

Output
ColA
(1,2,3,4,5)

there is no common key in the input ...
 Topic: New IBM datstage development looking for some help
rakesh.puli

Replies: 2
Views: 602

PostForum: General   Posted: Mon Feb 24, 2020 9:58 am   Subject: Re: New IBM datstage development looking for some help
I just started working on IBM Infosphere DataStage and Quality stage version 11.7.

I am looking someone will give me one to one training in my real-time situation. if anybody interested please send ...
 Topic: Multi-instance job with Oracle source and DB2 target
rakesh.puli

Replies: 7
Views: 1402

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Feb 16, 2020 2:02 am   Subject: Multi-instance job with Oracle source and DB2 target
Suppose if i want to load the metadata in sequential file at source stage, I will import the metadata from the table definition and load it into the sequential file stage, but I dont understand here w ...
 Topic: Multi-instance job with Oracle source and DB2 target
rakesh.puli

Replies: 7
Views: 1402

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Feb 16, 2020 1:25 am   Subject: Multi-instance job with Oracle source and DB2 target
From your points I understand that we cannot read a file from oracle connectorstage or anyother database connector stages. We can read the file from only filestages like sequential file stage. If we ...
Resolved
 Topic: Help on Transformer Looping
rakesh.puli

Replies: 5
Views: 1224

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 12, 2020 7:34 am   Subject: Help on Transformer Looping
Yes.
Resolved
 Topic: Help on Transformer Looping
rakesh.puli

Replies: 5
Views: 1224

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Feb 08, 2020 6:46 pm   Subject: Help on Transformer Looping
Hi Chulett/qt_ky

I tried using the looping variable @looping <=5 in transformer stage and assigned the input record to this looping variable and I got the ouput as below. thank you all for your ...
 Topic: Multi-instance job with Oracle source and DB2 target
rakesh.puli

Replies: 7
Views: 1402

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Feb 08, 2020 5:13 pm   Subject: Multi-instance job with Oracle source and DB2 target
Hi Chulett,

Here the source is only files, All these source files have different schemas.
But we have to read the files using the Oracle connector stage and load into target DB2 tables.

Thanks ...
 Topic: key change column with sort stage
rakesh.puli

Replies: 3
Views: 1049

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 07, 2020 7:26 pm   Subject: key change column with sort stage
What is the logic we have to apply to avoid using two transformers and copy stage? To use only one transformer and output to two targets and job design should look like this.


seqfile -> sort ...
 Topic: key change column with sort stage
rakesh.puli

Replies: 3
Views: 1049

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 06, 2020 2:51 am   Subject: key change column with sort stage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi

I have designed a job to remove duplicates using the key change column in sort stage. I have written the records with the key change value=1 into target1 file with constraint "keychange value = ...
Resolved
 Topic: Help on Transformer Looping
rakesh.puli

Replies: 5
Views: 1224

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Feb 01, 2020 8:30 pm   Subject: Help on Transformer Looping
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi

I have a requirement as below, I have to achieve the output like the below.
how I can do this with the @iteration variable in transformer and what derivation i have to give in the stage variab ...
 Topic: Multi-instance job with Oracle source and DB2 target
rakesh.puli

Replies: 7
Views: 1402

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Feb 01, 2020 5:32 pm   Subject: Multi-instance job with Oracle source and DB2 target
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi

I have a requirement like to load 50 DB2 target tables from 50 Oracle source tables or source files with different schemas with only using source as Oracle connector stage.

How can I achiev ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours