DSXchange

You can probably calculate the length and store it in a different field in the transformer (prior to the filter) and then use that field in the filter condition.

Regards,
Divya

Check out the values of the data of the TIMESTAMP field whether it complies with that of the Default TIMESTAMP value (Job's default settings). If not, change the default setting to match to that of the source data or you can import the TIMESTAMP data also as 'Varchar' and then convert to the desired...

Check out the values of the data of the TIMESTAMP field whether it complies with that of the Default TIMESTAMP value (Job's default settings). If not, change the default setting to match to that of the source data or you can import the TIMESTAMP data also as 'Varchar' and then convert to the desired...

What is the format of the values of 'RPT_D' field?

Regards,
Divya

What will the clustered key column do? I havn't used that before.

Regards,
Divya

Is your source file a static one? Are you loading the details to a destination table?

Can you explain you process and requirement with eg., so that it will be more clear.

Regards,
Divya

That helps!! I was jus wondering if I can use the same job for processing too. To be more specific, I want to split the input file to various other files based on the record type and then process the individual record types separately. I can put these into different parallel jobs and run as sequence...

Read as a Single Column then check for the length and extract the Columns by using substring Function. Totally in Transformer define 6 Columns Column1 SingleColumn[1,5] Column2 If Len(SingleColumn)=30 Then SingleColumn[6,9] Else SingleColumn[6,8] and so on for other columns. This code is as per the...

Svengiyil,

Good to hear that you got a good solution!!!

But jus curious to know whether you get the same output when you sort it by the key column ?? As per my understanding, you should.

Regards,
Divya

Howa about a wait for file stage in front of each input file stage. You can specify in the wait for file stage whether to wait for the file or continue regardless of whether the file exists or not.

Regards,
Divya

I still dont understand. Create the file for what??

Regards,
Divya

I am able to view my original file too :D Now I have another doubt, My actual file contains data of various record types, For eg. Lets assume it contains records of 2 record types(each fixed length), the field lengths are rowtype 1(1st character in file):5, 9, 5, 5, 6 rowtype 2(1st character in fil...

laknar wrote:Try the schema Definitions.

Enable the multiple instance invoke the same job for Various file formats.
Store the schema file infile systems.invoke the schema file through parameter.

I don't understand

Can you give me more explanation.

Thanks,
Divya

I am able to view my original file too :D Now I have another doubt, My actual file contains data of various record types, For eg. Lets assume it contains records of 2 record types(each fixed length), the field lengths are rowtype 1(1st character in file):5, 9, 5, 5, 6 rowtype 2(1st character in file...

The default delimiter is whitespace, So when I set the delimiter = none, its working now. Now I should try with my original file which contains lot of spaces between the fields in addition to the data. Will get back with my issues with the original file, Hope I dont have any :) Thanks a lot of of yo...