Search found 32 matches
- Mon May 04, 2020 9:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: combine 5 records into one records
- Replies: 8
- Views: 20737
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 IsNotNull(DSLink2.COL) then svar1:',':DSLink2.COL else svar1 svar2 : LastRow() Constraint : svar2 output column = svar1 Output : 1,2...
- Thu Mar 26, 2020 10:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: combine 5 records into one records
- Replies: 8
- Views: 20737
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 this with below two methods,but I didn't get the desired output.Can you please let me know how to achieve th...
- Thu Mar 12, 2020 1:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: combine 5 records into one records
- Replies: 8
- Views: 20737
- Wed Mar 11, 2020 10:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: combine 5 records into one records
- Replies: 8
- Views: 20737
- Wed Mar 11, 2020 12:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: combine 5 records into one records
- Replies: 8
- Views: 20737
combine 5 records into one records
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 5 records.Since there is no common key,I think like we cannot use lastrowingroup() function in transformer. I tried like this but i...
- Mon Feb 24, 2020 9:58 am
- Forum: General
- Topic: New IBM datstage development looking for some help
- Replies: 2
- Views: 13026
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 me a personal email message. Thanks. You can also try this. Learnquest.com. IBM training partner. htt...
- Sun Feb 16, 2020 2:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multi-instance job with Oracle source and DB2 target
- Replies: 6
- Views: 7053
- Sun Feb 16, 2020 1:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multi-instance job with Oracle source and DB2 target
- Replies: 6
- Views: 7053
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 read only from sequential file stage, then why we have to enable the run time column propagation and ...
- Wed Feb 12, 2020 7:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help on Transformer Looping
- Replies: 5
- Views: 6762
- Sat Feb 08, 2020 6:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help on Transformer Looping
- Replies: 5
- Views: 6762
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 inputs
thanks
Rakesh
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 inputs
Code: Select all
123
123
123
123
123
Rakesh
- Sat Feb 08, 2020 5:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multi-instance job with Oracle source and DB2 target
- Replies: 6
- Views: 7053
- Fri Feb 07, 2020 7:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: key change column with sort stage
- Replies: 3
- Views: 4887
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.
Thanks
rakesh
Code: Select all
seqfile -> sort -> transformer -> target1
-> target2
rakesh
- Thu Feb 06, 2020 2:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: key change column with sort stage
- Replies: 3
- Views: 4887
key change column with sort stage
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 =1" in transformer and other records key change column value=0 with constraint in transformer w...
- Sat Feb 01, 2020 8:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help on Transformer Looping
- Replies: 5
- Views: 6762
Help on Transformer Looping
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 variable and looping variable.Please help me with this Input record 123 Output 123 123 123 123 123 Thanks Rakesh
- Sat Feb 01, 2020 5:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multi-instance job with Oracle source and DB2 target
- Replies: 6
- Views: 7053
Multi-instance job with Oracle source and DB2 target
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 achieve this? Please let me know.
Thanks
Rakesh
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 achieve this? Please let me know.
Thanks
Rakesh