DSXchange

Hi All,

I have a requirement where i need to Read Datastage Job Logs from UNIX server.

Can any one share knowledge how to read Job Logs from Unix server.

Thx.

Hi Mike, This job is creating XML target file, hence we have to use so many transformers to generate only 2 transformation logic :- 1) To Field 1: Assign a hard coding 4 digit number like (2345, 7865, 3245) so on. 2) To Filed 2: Generate a Sequential Unique number for each record. Currently it is do...

Hi All, I have a Job where 70 Transformers is being used. These many transformers are degrading my job performance. I wanted to replace these transformers with some other stage. Function of Transformer :- Transformation logic which is implemented over transformer are :- 1) To Field 1: Assign a hard ...

Thx Mike.

My issue got resolved i have checked "Add checkpoints so sequence is restartable of failure" in sub sequence which was causing this warning.

This is one of sub sequence and where Parameter value will get change because it has timestamp. It will get change with every execution.

I tried to re execute with "Do not checkpoint run" gain it thrown warning "The current job run does not have the same parameters as its checkpoint record."

What is best way to remove this warning from Logs.

Hi All, In one of master sequence i have 6 Sub sequence. Some time when sub sequence fails and get restarted it is throwing a warning "The current job run does not have the same parameters as its checkpoint record." This warning goes off when i re run master sequence. Could any one please ...

Thx Mike,

Could you please make changes as past back schema file.

Hello, I am getting error in reading .csv file through a schema file. Schema file is :- record{record_delim_string='\r\n', delim=',', final_delim=end, quote=double} ( BRANCH_ID:String[10]; CLIENT_ID:String[10]; NOTES:String[200]; PIN_DEVICE:String[3]; CP_ROUTE_NO:String[4]; ) Error :- Copy_of_SYS,0:...

Thx Every one.

My issue got resolved.

Issue was with .CDX file. Thr was a different between metadata present on >DBF file and .CDX file.

Thx,

It didn't worked.

Any one else who can me.

I have to work with 8 only. Only issue is that some files are working and some are showing error ...?
Didn't able to understand why this abnormal behavior.

Do any one have experience over handling .DBF files

Folks, I'm trying to read data from FoxPro table's using Datastage ETL Tool.i coppy all files from Foxpro server to different folders over Unix bod. I am able to read 7 .dbf file out of 15 files.when i try to read other 8 .dbf files through ODBC stage,its throwing this error: SQLSTATE=01000, DBMS.CO...

Hi All, I am working on reading FoxPro server (.dbf) files. FoxPro server is mounted on Datastage Unix server. Then I am able to read data through ODBC connector stage. After making an entry to .ODBC.INI file. Issue: I am able to read some of (.DBF) file and for some (.DBF) file i am getting an erro...

I didn't get its solution ??

Hi, I am getting an error similar to what given here. i am using command as "ftp:\\tdbf-iafil-sc1.d2-tdbfg.com\mbct\CIS\DATA\sys.dbf" Gave error :"FTP_Enterprise_45: Error occurred during initializeFromArgs()." and " uri is having invalid syntax. uri : ftp:\tdbf-iafil-sc1.d2...