DSXchange

Run below command dsjob -report <proname> <jobname> IN $dshome/bin directory.

Thanks
Kishor

use following report for getting all information source and target.

dsjob -report <proname> <jobname> DETAIL


Thanks
Kishor

SELECT CONTAINER_RID, XMETA_REPOS_OBJECT_ID_XMETA, XMETA_CREATED_BY_USER_XMETA,(TIMESTAMP('01/01/1970', '00:00:00') + (XMETA_CREATION_TIMESTAMP_XMETA / 1000) SECONDS) - 8 HOURS AS XMETA_CREATION_TIMESTAMP_XMETA ,XMETA_MODIFIED_BY_USER_XMETA, (TIMESTAMP('01/01/1970', '00:00:00') + (XMETAMODIFICATIONT...

Check whether the unattached or unused links,very small icons are in the processing area.Small icons are somewhere in developing area screen.Scroll up and down ,left and right directions.If you dropped some stages and minimized to very very small icons then you don't concentrate on this. Before this...

Dear all, Can anybody suggest me how to generate the reports for below purpose. 1> can we check how many jobs are running and what are the status for that(like running/aborted/completed). 2> report for what are the current status of job like 20%,40%,60% ..completed. 3> can we take the report in grap...

1. FYI, you can also use DB2 connector for bulk loading. 2. In bulk load, before inserting the records, the bulk load writes a log file for the ongoing processes in the job. If you are having some warnings in your job then for each row and for each column it will write that log into the file. that i...

you have not handled for the columns for which you are getting null from the source. Try one of these solutions: 1. Use IsNull() or IsNotNull where ever required in Transformer. 2. Also if your target is a seq file then Use Null field value constraint and make equal to ''. thats it 3. If you just wa...

A good logic. I think the simplest way to do it is in the source query itself if ur source is a database.
Use Decode, that will be more helpful than if else.

Based upon wat condition/logic, you want your rings to be divided??

Tfr is a heavy processing stage when speaking of 4 million records.
Tfr will take more time(differenct can be in seconds also) than (2) and (3).
And as everybody (2) and (3) are equal, I think use (3) option.

is your reject target a seq File?

Plz check if you are using any stage variables, if yes then change their datatype to varchar(255)

I also found the same warnings while using connector stage. The solution which I applied was- In director I added a message handler and demoted those warnings to info.

Whats ur target stage?
Seq File or Database

asorrell wrote:Is the sequencer changing any paramters? Specifically check to see if it is changing the APT Config file.

for individual file we are not changing any parameter. All values are hard coded.