DSXchange

HI Aquilis, Actually I need below condition requirement If (Trim(OKCUA4='') and SR_TR_OCUSMA.OKCUA3 = SAP_DESC) Then SAP_VALUE Else if SR_TR_OCUSMA.OKCUA4 = SAP_DESC Then SR_TR_OCUSMA.SAP_VALUE else '' Here is Two Tables 1 SR_TR_OCUSMA is one table OKCUA3, OKCUA4 are the fields 2 SAP Table is second...

Hi Friends, When i generated Union script in ODBC connector its showing the failure message. Please can check this one is correct or want to write some other way. below are the errors IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42S02: Native Error Code = 208: Msg = [IBM (DataDirect ...

Hi,
Can any one help in this case,

if OKCUA4='' and OKCUA3 in (counties) then OKCUA2
else if OKCUA4='' and OKCUA3 not in (counties) then OKCUA3
else if OKCUA4 in (counties) then OKCUA3
else OKCUA4

Hi Friends, Please Help in the below warning, its occured in my job REPORT: When checking operator: When binding input interface field "COUNTRY_CODE" to field "COUNTRY_CODE": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use a modify op...

Please can help in this canse

if OKCSCD in('DE') then substring(OKCUA4,7, end) else Blank

Hi,
When I prepared job in the output under column Instead of empty it showing "0"value, but i didn't given any integer value for the row but it showing "0", can any one share their experiance how to solve this problem

The output value storing in Sequencial file

Hi Friends,

Is there any chance convert the data from Oracle(Source) to .CSV(Target) format through DATA STAGE

Hi Friends,

How to access the Excel file (Source), May its like to import through sequencial file definition or some other plug-in side. Can explain to me.

How define the fixedwidth file, I have little bit doubt, Please explain this one also.

How to skip the first 102 rows and moreover if I skip the rows, that job will can give good result. Please can provide the proper guidance in answer

Hi DS Guys,

When I run the job, target table has loaded 102 records after that due to some problems job has been failed or Aborted. After solving the problem I want the to load the data from 103 record onwards (I dont want to load from 1st record).

Hi DS guys, I have getting warnings when i am run the job. Please can tell to me how to solve these bellow common warnings. These warning gettings after Aggregated stage used and its transfer to sequencial file. 1. Sequencial_File_26,0: When Checking operator: When validating export schema: At field...

Hi, I have one doubt, I am generating the mark list for a school, Here I need "AVG" per subject , and I need rank wise students. Example: In VI class have 50 students and 5 subjects, I need each subject "AVG" of 50 students, and need Highest score basis rank. I need to fill AVG i...

Hi Friends, Can give me the suggestion (logic) how to find difference time between start_time and end_time. I am tried one logic in oracle its giving good results but when i am trying in DataStage its not working. Once again i am requesting friends can give suggestion on this issue Example: end_time...

Hi,
If any can give the information about the difference between Fileset, Sequencial File, Lookup Fileset. Its help for me to understand which one need to use suitably in my project Either FileSet or Sequencial File

Hi,
I am not yet implemented "SCD2". Can help some one how to Implement "SCD2" in DataStage Parallel Edition.