DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 110 matches
Author Message
 Topic: Choosing right ETL tool to build new DW enviroinment
cherry

Replies: 6
Views: 2622

PostForum: General   Posted: Fri Jun 06, 2014 1:18 am   Subject: Choosing right ETL tool to build new DW enviroinment
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: Choose Datastage as ETL tool
Dear All,

Good Day,

We are building a datawarehouse from scratch which we don't have at the moment.

We have daily transactions of apprx 100 million records to transform and load into our new ...
 Topic: Generate Id's based on the key field
cherry

Replies: 4
Views: 1458

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jan 15, 2013 4:59 am   Subject: Generate Id's based on the key field
Hi Chulett,

Let not confuse with the sample data above. To make it simple it is shown as below

INPUT -->

ID_NUMBER

1234
1234
1234
1111
2345
2345


Output required ---> ...
 Topic: Generate Id's based on the key field
cherry

Replies: 4
Views: 1458

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 14, 2013 7:27 am   Subject: Generate Id's based on the key field
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Dear All,
I have the following requirement. I have a member who can have multiple benefits as shown below:
MEMEBR_ID NAME BENEFIT
NMBR001 AAA 1
NMBR001 AAA 2
NMBR002 BBB 1
NMBR002 ...
 Topic: convert column data in to rows
cherry

Replies: 4
Views: 1484

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 18, 2012 5:31 am   Subject: convert column data in to rows
Hi Ray,

The name field is not fixed with number of delimiter's say for one record it might have 5 delimiters and other row would have more than 5. In this case iam not sure if column import stage w ...
 Topic: convert column data in to rows
cherry

Replies: 4
Views: 1484

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 18, 2012 4:27 am   Subject: convert column data in to rows
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi All,

I have the below scenario and my pinput data is as below

Input
-----
Id, Name
1, r;b;c
2 a;d;g;h;j

Name field has data which is ';' delimited but it is one record

I would like ...
 Topic: Rows to Columns
cherry

Replies: 1
Views: 1194

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 12, 2011 2:07 am   Subject: Rows to Columns
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Dear All,
I have a scenario as below:

Input data:

IDNumber Code
12345 1001
12345 1006
12345 2001
67891 1003
67891 1004
67891 1006
67891 2001
67891 2004
67891 2008
1357 ...
Resolved
 Topic: SQL3502N The utility has encountered "XXX" warnin
cherry

Replies: 2
Views: 2648

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 21, 2011 2:17 am   Subject: SQL3502N The utility has encountered "XXX" warnin
Thanks Michael,

I checked and found the data from imput is not matching to the output dataypes and the data being truncated.

Regards
Cherry
Resolved
 Topic: SQL3502N The utility has encountered "XXX" warnin
cherry

Replies: 2
Views: 2648

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 21, 2011 1:51 am   Subject: SQL3502N The utility has encountered "XXX" warnin
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi All,

Iam trying to load data from a dataset to DB2 using Bulk load stage.

Iam getting the following error:

SQL3502N The utility has encountered "200" warnings which exceeds the total numb ...
 Topic: Date Population
cherry

Replies: 3
Views: 1683

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 06, 2010 12:02 am   Subject: Date Population
Thanks anbu for th esolution. Let me try and get back to you.
 Topic: Date Population
cherry

Replies: 3
Views: 1683

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 05, 2010 9:33 am   Subject: Date Population
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi All,

Good Day..,

I have the following requirement.
From the source I would get only the START DATE and I need to populate END DATE in the Output file.

Greatly apprciated if anyone has so ...
 Topic: Column to Rows
cherry

Replies: 1
Views: 895

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed May 12, 2010 4:19 am   Subject: Column to Rows
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi All,

I have the following requirement.

My Input data looks like:
SAP_CODE AIM_PART CRD_PART ACM_PART
1 M 1 2
2 F 2 1
3 U 3 3

My Output should look like:

SAP_CO ...
 Topic: DSD_GenerateEvents.B:LinkReport
cherry

Replies: 1
Views: 1352

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 16, 2010 2:25 am   Subject: DSD_GenerateEvents.B:LinkReport
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi All,

Iam getting the following warning message:

DSD_GenerateEvents.B:LinkReport for Job009_CC_AggrYTD.EDW01_PAYMENT.LN_CompassConv_IN not found.

Could some please help me what this message ...
 Topic: Substring function problem
cherry

Replies: 8
Views: 31870

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 09, 2010 3:45 am   Subject: Substring function problem
Try this DSLink149.INTFC_FILE_CATG[1,4]

Regards
Cherry
Workaround Reported
 Topic: Lookup
cherry

Replies: 4
Views: 1554

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 09, 2010 1:06 am   Subject: Lookup
Hi All,

In My previous message I have mentioned, the job type as Parallel.

The job type is server.

Many Thanks


Regards
Cherry
Workaround Reported
 Topic: Lookup
cherry

Replies: 4
Views: 1554

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 09, 2010 12:56 am   Subject: Lookup
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi All,

We recently upgraded from 8.0.1.2v to 8.1.00v.

In 8.0.1.2v iam doing lookup directly on the table. But the same job design is not working in 8.1.00v.

In 8.1.00v, I need to add a hash ...
 

 Jump to:   



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