DSXchange

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...

Input records are as follows,
TRSCX
TSRPX
TRCPX
TRGIX
W146#
TIKRX
TIIEX
W146#
TRRSX
TIHRX
TIKRX
TRCPX
TRSCX
TIQRX
TRIEX

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...

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: ...

We are facing the problem only for the imported jobs.

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....

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...

My timestamp value is in the format of (10/21/2010 2:57:55 PM)

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.

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...

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

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

Which index gets automatically created with primary key?

a) B-tree Index
b) Bitmap Index
c) Funcation Based Index
d) Index never create automatically

Can we define both unique and non-unique keys during data modeling phase?

a) Yes
b) No

Can snowflake schema be later converted into Star schema?

a) Yes
b) No

Thanks in advance......