DSXchange

Hi , Datastage version=8.1.0.0 We have reconciliations job. 1 source file - extracting data using ECC stage . 2 source file - other team drop the file in datastage server. we have many reconciliation jobs. one of reconciliation job had issue. record value is same in both sources , but still reconcil...

My source and target are both CSV file format.
Tranformer looping option not available in 8.1 version.


Thank you.

Hi , we are using datastage 8.1. my requirement is : Input is like this customer|Count A|4 B|1 C|2 Based on customer count value , need to generate that many output columns for the same customer. output required as Column1 | Column2 A|1 A|1 A|1 A|1 B|1 C|1 C|1 please help me how to get output as req...

Hi Teasm , SAP login/password error from Data Stage ABAP Stage, when validating stage in abap stsge , getting error that "S103268 is not a CPIC-C user." Recently SAP login password is changed, while connecting SAP from Data Stage ABAP stage, unable to connect SAP due to above error. Same u...

There are LFM1, LFA1and LFM2 tables in SAP all contains data.LFM1, LFA1 data are successully extracted from DataStage using ABAP stage but data is not being extracted from LFM2 through ABAP stage.This job contains ABAP stage ---Tranformer -Sequential file stage(No tranformation logic).This job finis...

In other job , we had abap stage, in that we have 3 tables with inner joins between tables, data will fetching without any issue.
But particularly in this one job, we had abap stage , Required to extract only one table , but still data not fetching.
but in other jobs it extracting without issue.

Hi ,

in one of the ABAP stage , we want to extract data from one SAP Server.Job completed without fetching any records .
from Remaining abap stages data fectching.

Please let me know why data not fectvhing from one abap stage.

Hi Team , In our project , we are doing reconcillation on 2 sources. in both source , one source file is in .txt format and other source is in form of .csv . In reconcillation job before comparing 2 sources , in transformer stage , we are trimming all fields in both source files. for reconcillation ...

Hi, My requirement is Reading CSV file,next check the number of columns in each record in CSV file = 3 or not? Input : 1 2 3 A b c d e 6 1 2 3 4 E T L 1 2 3 Required files as column count in record= 3 Output : 1 2 3 E T L 1 2 3 Create error file ,column count in records <> 3 into error file Error fi...

My requirement : uploading multiple files to different folders(One FTP server ) which are in target FTP server using datastage job or calling unix script in datastage .
please help me datastage job design or please provide unix script if you have.
Thank you.

Hi , My requirement is Sending multiple files, based on file name to different folders (same FTP Server). File Name Destination Path A.txt /Output/AAStndldGen B.txt /Output/BBStndldGen C.txt /Output/CC send output files to target FTP server(Same FTP server for all uploading file) based on file name ...

Hi Craig,

when in next run this failed job reset, in log there is no log like "From previous run...".

Thanks

Yes, its really a server job.

Hi All, Job designing like this : DB2 stage - > XFM stage -> DB2 stage source query used in db2 stage: 'select 'S' as no ,'Sucess' as def_va ,REQUEST_ID,REQUEST_SEQ_NO from MDCRDBA.textract_recurr_tbl WHERE REQUEST_ID=#REQUEST_ID# AND REQUEST_SEQ_NO=#REQUEST_SEQ_NO# and REQUEST_STATUS_CD <> 'F' ; ' ...

Hi All, My client requirement is migration of jobs from 8.1 version to 11.3. Taking all jobs export from 8.1 and directly importing into 11.3 version and compiling all jobs, it will work ? or need to migrate from 8.1 to 9.x , then again 9.x to 11.3? please suggest best approach . Thanks & Regard...