DSXchange

(1) Character ] on mainframe (with a HEX VALUE BB ) is being converted to ' ' (blank) (SEQ of 1A) in Data Stage Server.

(2) Character ! on mainframe (with a HEX VALUE 5A ) is being converted to ] (SEQ of 5D) in Data Stage Server.

STEP (1) Downloading the Mainframe File as Binary. STEP (2) Reading downloaded file through CFF Stage. This is working perfectly fine for all chanracters except ! and ] characters in mainframe. When I compare the data between mainframe data and final processed data in UNIX Character ! in mainframe i...

I made the two changes and it seems that it is working but there is a sub routine that checks the actual row_count that was moved from table source to text target. After calling the COMMON JOB, I am calling a Routine but is now returning me 0 rows, even when the job does show more than 0 rows were s...

So you mean

(1) Open Job and "CHECK" Allow Multiple Instances under Paramter Tab.
(2) In Sequencer from where the Job is called Pass the "Table Name" to
Invocation ID under Job Activity stage

Will this address my requirement?

Below is the complete flow. (1) Job 1 reads a text source and loads a temporary Teradata Table. (2) Job 2 reads the Temporary Table and saves row count to a text file. (3) If Text file in Job 2 has more than 0 rows, it runs a BTEQ script to process rows from temporary table otherwise it terminates. ...

What's ur target?

Here is what I am doing Parallel Job 1: Getting the file as binary/EBCDIC on ETL Server (File A) through FTP Enterprise Stage Parallel Job 2: Reading File A through CFF stage and using the Cobol File Definition and then loading the data into a table. The translation is happening fine except for 2 ch...

(1)
Is there a list that explains what characters of mainframe (EBCDIC) will NOT be converted properly.

(2)
Is there a way to solve this in Parallel Job?

(3)
Can Server Job is used to convert instead?

I have a mainframe source file that has a column defined as PICX(1). The values on those columns can be anything like 1,R,Y,>,L,{,},[,] etc. There is 1 character that is somehow not translated properly. Below are the details. (1) On Mainframe Editor (HEX ON) that character shows as ] with HEX VALUES...

I guess I should have been specific. I don't know if it's teradata or datastage that is rejecting the row. This is the DDL to create Table. CREATE SET TABLE EMPLOYEE_STG ,NO FALLBACK ( YR_MTH CHAR(6), AD_CO_NBR CHAR(5), DLR_PA_C CHAR(5), DLR_NBR CHAR(5), VIN CHAR(17), AMOUNT DECIMAL(9,2), VO_CD CHAR...

I have a flat file that goes into a TERADATA Table in a parallel job. The TERADATA Table has NON UNIQUE KEY . But when I load the source data into the target table the Director displays warnings about the duplicate rows and rejects them. When I am creating teradata table and the index in NON-UNIQUE ...

I am running one Job that has aborts with the below error message

"main_program: Creation of a step finished with status = FAILED."

It doesn't has any other information what caused the ABORT. How to find out what actually the problems are?

Hello, I am processing an employee file and the Name Column has some hidden characters some of them like Horizontal Tabs (009) Carriage return (002) One way to check is to Use the SEQ() function on each of the caharacters on the Name Column, check the Value and replace them with something else...exa...

Yes I can very well do that. The only problem is if the columns I have to make into rows is too much then I will have too many transformers. Pivot will work best for me.

I have a source file that has 18 columns, 2 of them make Primary Key. I want to convert some of the columns in a row to multiple rows. Example below. INPUT SOURCE FILE PKey CustNum Add_1 Tel_1 Zip_1 Add_2 Tel_2 Zip_2 Add_3 Zip_3 Tel_3 Total_Amt Total_Rebate OUTOUT FILE DESIRED AS PKey CustNum Add_1 ...