DSXchange

Sorry about that. Database is oracle 11g. Columns are like below with user defined structure. LP2300_ID NUMBER CONSTRAINT HAP_NN_CLPP_2300A#LI NOT NULL, LP2000B_ID NUMBER, LP2000C_ID NUMBER, FILE_ID NUMBER CONSTRAINT HAP_NN_CLPP_2300A#FI NOT NULL, CLM_CLAIM CLM_SEGMENT_TYPE, DTP_ADMISSION DTP_SEGMEN...

Hi All,

I have a requirement to read the data from segment structured tables.

I am using Datastage 11.3 version. Please suggest me to read the data in this table from DdataStage.

Thanks in advance.

Thank you all for your wonderful suggestions.

Thanks for your suggestion CHulett. I have 24 columns not 5.

Hi JRodriguez, Thanks for posting your idea. I thought of this approach before. There is a difficulty in this. I have to retain the rank of the columns. Lets say col3 value is already in col1, I have to move col4 to col3 only if it is not a duplicate of existing columns. Please let me know if there ...

Hi All, I have got a requirement to eliminate the duplicates after concatenating a set of columns. Col1 value: 123 Col2 value: 234 Col3 value: 123 Col4 value: 222 Col5 value: 222 After concatenating with pipe I should get the value 123|234|222|| I have the below logic to achieve this result: Appendi...

Thanks Chulett.

Thanks Chulett for your quick response.

The provided link has the needed information.

Do you have any idea to know the column that is getting truncated?

Thanks in advance.

Hi All, I am trying to load a file with 700 fields into a table. I used sequential file stage to read the file. I am getting the below warning message. "Input_Stage,0: External string too long. Imported only 1 out of 2 external characters. Ignoring last 1 characters up to delimiter." How d...

Hi All, I have some data in a dimension table which contains address fields like Address lin1, address line 2, state, city, zip code and zip code extension. All the addresses are US based addresses. I have to validate all these addresses and identify which are invalid. Is there any webservice to val...

11.3 client is installed on 32-bit windows 7 and working fine now.

I have registered Component 'MSCOMCTL.OCX' by downloading it from internet and all set.

Thank you all for your inputs.

Hi All, Datastage 11.3 client is installed on Windows 7 enterprise edition desktop. It is a 32-bit OS. I am trying to open transformer inside a job and it is not showing up :( I am trying to open director client. It is throwing the below error. Run-time error '339': Component 'MSCOMCTL.OCX' or one o...

I am trying to configure Data Masking stage in parallel job. when i execute the job, getting below error: Failed to load ODPP library. In case of ODPP version 9.1, add the path to ODPP libraries to system path. In case of ODPP version 1, make sure that ODPP libraries exist under <Information_Server_...

Taylor, What version of datastage are you using?