DSXchange

Hi All, Kindly advice to process the below file : 001234 ABC ABCD-PEFF 07-24-2020 14:33:03 07-24-2020 14:33:03 AB1234 A012 002 AB POINT AAAA 003 AB APPL ID RED 004 AB TYPE 005 AB PART ID 01234 006 AB PART DET ID 020 AB ALPHA DESC NAME ABC 023 AB CONSOL NO 024 AB ALT KEY 01234 000 AB STOP 004567 ABC ...

Hi Ray,

The Transaction is set to '0'.

Thanks.

Hi All, Kindly clarify the below on Teradata Connector: I have a job that writes to TD . First step is to insert the data to temp table and in after sql we are reading the data from temp table and insert into main table For instance if the After SQL statement fails in the middle of the execution , f...

Ray & Craig,

Thanks for the responses.

Hi All, I have to remove the empty tags in XML. My parent tag in the xsd has the min occurs =0 and child tag associated with the parent has min occurs =1. If I don' t receive parent value then i should not send the child tag . Since the min occurs for the child tag =1 , the tag is getting populated....

Hi qt_ky,

Currently we are using JDBC connector stage to load the data. But trying out options and do a POC .

Please Advise,

Thanks,
Kumar66

Hi All,

Any help is appreciated.
Please Advise.

Thanks,
Kumar66

Hi All, I have a requirement where I need to insert records into MySQL table using SSL connection. Currently we are using JDBC connector stage to load into MySQL table. I am trying out options to use java transformer or java client stage for target. Since I am inexperienced in java, I need help here...

Hi All,

The issue has been resolved. I added single space i.e ' ' for the null values rather ''.

It worked.

Thanks.

hi Chulett,

Since it is RCP job, I am confused to proceed
further.
Please advice

Hi All, I have a RCP job OracleConnector ----> XFRM----->FILE when the query is excuted I am getting the follwoing error: Error creating schema ( record( PROJECT_KEY:nullable string[max=50]; PN:nullable string[max=100]; MID:nullable string[max=32]; LN:nullable string[max=30]; FN:nullable string[max=...

I tried by breaking the last filed through looping and remove duplicate on the entire row so no two rows are loaded.

But trying to find out to replace rather than breaking the field.

Thanks

Hi All,


I have a requirement where the last field in a row needs to contain unique value

for e.g.
input

aaa,rrrr,1|2|1|3
bbb,eee,1|2|2|3

output:
aaa,rrrr,1|2|3
bbb,eee,1|2|3

Please advise.

Thanks.

Hi All,

We are in the process of migrating the datastage jobs from SMP to Grid environemnt.

Any special considerations needs to be taken care in the migration.

Kindly assist me.

Thanks,
Kuamr66

Hi Chulett,
Thanks for the reply. I have created multi instance job. As you mentioned I am worried only about the large number of instance.