DSXchange

It seems your source system is in mainframe (assuming from your volume of data), if so why u need to split the file. why cant u look up as it is? If u need to split, you can use the INROWNUM function or "Abort After Rows" option in transfromer. so that u can calculate and cut the output fi...

So in this case,
DSJ.STAGEDNDTIMESTAMP can be captured in next comming stage to what the time stamp to be determined.

what DaleK said is also seems to be more simple

This is the one of the typical sample code which u can make use InputFileName = <file name> OpenSeq InputFileName To InFileVar Locked Else Call DSLogWarn("Cannot open ":InputFileName , "FormSUD") End ReadSeq FileLine From InFileVar On Error Call DSLogWarn("Error from ":...

Read the other files max(value) and pass it as an variable to this job, this can be done even through batch jobs. so that u can increment based up in the the parameter value.

If i understand properly, u need to append your output with some counter based up on your existing counter value with the increment of ten. For this is the case, your need to read the output file once before the process inorder to find the max of value. if that would be too big file, you can also wr...

Hi, i have a file with 3 million records. I know this is not very huge file for ETL tool to handle. Though i use very simple sequential stage to another seq stage conversion, i faced error, job got aborted. so i thought this may be file based restriction in operating system. so i tried with FileSet ...

As the help says, upsert is regular insert and update, where as load make use of bulk load technique, hence i guess it by passes the buffer.
Can u get any info from the Err Code?

Do you have any idea, what else should be taken care while we restarting the server.
Is there any other services should be started manually....

Is it really must to do a sort using a sort stage before an aggregator everytime, bcoz when i tried with an un presorted data it worked same.
In the other case, why cant we maintain the partition as "Same" in Aggregator followed by sort stage.

As we know sequential file wont work under parllelism, will this some way related to this

Thanx lalitha,
Your suggestion worked out. :D .
Do you have any idea why it got stoped

Hi, I could not under much of ur complexity, But For header record, as per ur idea u can use Read First Rows =1 so that it reads only the first row. For Detial you can mark First Line is Column name = True so that it wont read the first record and starts with second record. Hope it wont read the tra...

Hi, I could not under much of ur complexity, But For header record, as per ur idea u can use Read First Rows =1 so that it reads only the first row. For Detial you can mark First Line is Column name = True so that it wont read the first record and starts with second record. Hope it wont read the tra...

vmcburney wrote:It's on the Diagram menu - Show performance statistics.

This option is also checked but it does not work. I think this option is only for the display of Number of rows passing through the link. Unfortunately even this option dosent work.