DSXchange

Hi every one, we have a new requirement to replace the target Netezza Database with Snowflake Database. we have lot of jobs to change the Netezza connector to Snowflake Connector stage. Do we have any tool or automated procedure to replace the Netezza connector with Snowflake Connector stage? or we ...

I know it is old post, but it may help others, so I am posting the work-around logic that worked well for me. step 1. While reading the parent record in filter condition used RECORD_TYPE='AB00' Or RECORD_TYPE='AB01' Or RECORD_TYPE='AB02'. So the output from the above step is: master record with 'AB0...

yes you are correct Chulett. I am getting the same issue as what is there in the link you have provided. I will ask the administrator to rebuild the Index and the funny thing is when we asked for the Admin for the reason why we are not able to see the datastage jobs he suggested to check the datasta...

Hi All, We just got the DataStage access and when we logged into DataStage Designer there are no jobs in repository. But I can see the jobs in DataStage Director. When we opened the Designer from Director window we are able to see the jobs in Designer. Why we are not able to see the jobs when we dir...

Thanks FranklinE for the explanation. How can we read the file sequentially as is using CFF stage because i have different record layouts with different lengths. If I read the file as is then i can dump it to sequential file and do the rest of processing. I asked the Mainframe developer to add the p...

Hi All, I am trying to read a COBOL File with CFF stage. The file has multiple record types (AB00,AB01,AB02 etc). Each record type will have different length. Sample data is below. Header -> Abc.txt20150210 Parent -> 00000AB00XXXXXXXX99TTTT Child 1 -> 00000AB01yy1234 child 2 -> 00000AB02pp123456789 ...

Hi,


I tried keeping the ROW LIMIT in CFF stage to 1 but still Could to able to read the file except header and trailer record .
My record schema is below.
{record_format={type=implicit}, delim=none, quote=none, binary, ebcdic, native_endian, charset='ASCL_ISO8859-1', round=round_inf, nofix_zero}

Hi All, Iam trying to read a Cobol File whch has 19 multiple subsegments plus Header and trailer. All these subsegments have different lengh and I have 19 cobol copy books to read the file. I am reading the file based on Record type. I have given all the 19 cobol copy books along with the Header and...

Bulk with Update mode the data is loading into main table. But in datastage log its showing Total number of rows inserted is : 0 and Exit code 4. But Bulk with Load mode data is not loading to main table and datastage log its showing Total number of rows inserted is : 0 and Exit code 4. need to inve...

The job is getting completed successfully so the error and log tables are getting dropped. But the same code is working as expected in DEV. I checked all parameters related to Datastage and are same both in DEV and UAT. So i sent email to DBA for checking this issue and waiting for the reply from th...

hi Vinoth, I will have always inserts so im using LOAD option and its working even though the data is already exists in table in Lower environment (DEV). The issue is coming in UAT and as Im first time loading table so the target table is empty. I even tried with Load type as UPDATE but still zero r...

Hi All, I have an issue with teradata bulk load. The job will load data from dataset to teradata database (teradata connector used). When I run the job with BULk load the data is loading to WORK table but not to the main table. The log showing 0 records inserted in main table and no abort except the...

correction to the above post...
12,3 ---> 12 tasks but restrict to run on only 3 nodes.

12,3 ---> 12 nodes but restrict to 3 servers. Smaple config for 6,3 is below. <Dynamic_grid.sh>Information: Generated Dynamic Grid Parallel Configuration File (TotalPartitionsRule=cores, Resource Disk Allocation=all, Scratch Disk Allocation=all): { node "Conductor" { fastname "SERVERN...

The mistake I have done is , not keeping the same number of spaces

Its working fine now. Thank you so much Chulett!!