Search found 35 matches
- Tue Oct 22, 2013 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Len function issues in VARCHAR columns
- Replies: 7
- Views: 3314
Hi, Tried with this statement If (Len(Trim(InputColumn)) = 5 Or Len(Trim(InputColumn)) = 6) Then 1 Else InputColumn=0 Have Constraints in the transformer (InputColumn=0 OR 1) to verify the output Thanks. Tried that option as well, seems like we have some special charaters coming from source which w...
- Tue Oct 22, 2013 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Len function issues in VARCHAR columns
- Replies: 7
- Views: 3314
Len function issues in VARCHAR columns
Input records are as follows,
TRSCX
TSRPX
TRCPX
TRGIX
W146#
TIKRX
TIIEX
W146#
TRRSX
TIHRX
TIKRX
TRCPX
TRSCX
TIQRX
TRIEX
TRSCX
TSRPX
TRCPX
TRGIX
W146#
TIKRX
TIIEX
W146#
TRRSX
TIHRX
TIKRX
TRCPX
TRSCX
TIQRX
TRIEX
- Tue Oct 22, 2013 8:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Len function issues in VARCHAR columns
- Replies: 7
- Views: 3314
Len function issues in VARCHAR columns
Hi, Need to load the source records which must be 5 or 6 characters long into the target table. Source field Data Type - VARCHAR (15) NULLABLE column Target field Data Type - VARCHAR (15) NULLABLE column When I use the below function, If (Len(Trim(InputColumn)) = 5 Or Len(Trim(InputColumn)) = 6) The...
- Thu Jan 05, 2012 1:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partition Read in ORACLE connector stage
- Replies: 3
- Views: 4338
Partition Read in ORACLE connector stage
Hi All, Two tables created in ORACLE without any partition method. Eg: Table1 and Table2. While trying to run the job using the Table1 with property in ORACLE connector stage with Enable Partitioned Reads : Yes Partitioned Reads Method : Rowid hash Job aborts : "Error code: 923, Error message: ...
- Wed Nov 30, 2011 1:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to open Teradata & Oracle Connector stage
- Replies: 3
- Views: 2075
- Wed Nov 30, 2011 12:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to open Teradata & Oracle Connector stage
- Replies: 3
- Views: 2075
Not able to open Teradata & Oracle Connector stage
Hi,
Existing job which was developed in Datastage8.5.1 and imported the same job in Datastage 8.5.0 version, we are not able to open Teradata and Oracle connector stage properties.
pls help me out....
Existing job which was developed in Datastage8.5.1 and imported the same job in Datastage 8.5.0 version, we are not able to open Teradata and Oracle connector stage properties.
pls help me out....
- Fri Aug 05, 2011 3:49 am
- Forum: General
- Topic: Link Count information
- Replies: 1
- Views: 1321
Link Count information
Hi, How to get the Link Count information from a job. In a job if im using 6 stages for each link i need to get the total number of rows fetched till the last stage. Link level information starting from source stage till the target stage. Based on this need to create an routine. :( Thanks in advance...
- Wed Nov 24, 2010 4:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sum Timestamp value
- Replies: 5
- Views: 2071
- Wed Nov 24, 2010 3:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sum Timestamp value
- Replies: 5
- Views: 2071
Sum Timestamp value
Hi,
I need to group by based on BUSINESS_DAY_DATE,STORE_ID and TRANSACTION_ID and get the sum of an SIGN_ON_TIME which is an timestamp value.
Should i convert this Timestamp to dfloat before summing would an correct option?
Can anyone help me on this.
I need to group by based on BUSINESS_DAY_DATE,STORE_ID and TRANSACTION_ID and get the sum of an SIGN_ON_TIME which is an timestamp value.
Should i convert this Timestamp to dfloat before summing would an correct option?
Can anyone help me on this.
- Thu Jul 08, 2010 4:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Message Trigger jobs using UNIX
- Replies: 3
- Views: 2349
Message Trigger jobs using UNIX
Hi, Job need to be run whenever their is an message posted in the Queue, since its an real time scenario their is no time frequency of the messages available in Queue. When an job is triggered if message is received in Queue, job status is still in "Running", then if any other message hits...
- Thu Nov 12, 2009 11:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading the Dataset
- Replies: 5
- Views: 3456
Reading the Dataset
Hi Guys,
I have a dataset which was loaded in 2 nodes, can we read the same dataset with 4 nodes.
If so how can we do this?
Regards,
Siva Kumar
I have a dataset which was loaded in 2 nodes, can we read the same dataset with 4 nodes.
If so how can we do this?
Regards,
Siva Kumar
- Thu Nov 12, 2009 11:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null values to Dataset and Sequential File
- Replies: 1
- Views: 1894
Null values to Dataset and Sequential File
Hi Guys,
Can we pass empty values to dataset & sequential file ?
Can we pass NULL values to dataset & sequential file ?
If so then please let me know how we can read that values in dataset and sequential file.
Regards,
Siva Kumar
Can we pass empty values to dataset & sequential file ?
Can we pass NULL values to dataset & sequential file ?
If so then please let me know how we can read that values in dataset and sequential file.
Regards,
Siva Kumar
- Fri Apr 03, 2009 4:21 am
- Forum: General
- Topic: Reg: Indexing
- Replies: 1
- Views: 1398
Reg: Indexing
Which index gets automatically created with primary key?
a) B-tree Index
b) Bitmap Index
c) Funcation Based Index
d) Index never create automatically
a) B-tree Index
b) Bitmap Index
c) Funcation Based Index
d) Index never create automatically
- Fri Apr 03, 2009 4:17 am
- Forum: General
- Topic: Reg: UNIQUE KEY
- Replies: 2
- Views: 1757
Reg: UNIQUE KEY
Can we define both unique and non-unique keys during data modeling phase?
a) Yes
b) No
a) Yes
b) No
- Fri Apr 03, 2009 4:15 am
- Forum: General
- Topic: Star schema VS Snowflake schema
- Replies: 2
- Views: 2353
Star schema VS Snowflake schema
Can snowflake schema be later converted into Star schema?
a) Yes
b) No
Thanks in advance......
a) Yes
b) No
Thanks in advance......