DSXchange

Just Curious.. If we are to build that design can it ever be in parallel mode?

Anyway its a csv file. Why cant you define your metadata as varchar? Thats should solve your problem I guess.

Write your header and trailer to two different files and use a cat command in the after job subroutine to concatenate the files.

'mv' is the move command. What craig says is, we have two options inside the job properties, before and after commands, which would execute before the job is run or after the job is run as the name suggests. The unix command to move the .xml files to an archive folder can be given in the after comma...

Server or parallel, while you import the copybook DS will prompt for flatterning. Give yes and you will see all the occurs columns separately.

Okay. More questions. 1. What is your record length? From your examples it seems to be small (Unless you skipped some columns). 2. What can be the maximum volume of your file? If these are smaller records and the volume is not very high, I will suggest you to go for a Server job, use a sequential fi...

however i tried by using StringToDate(select_stats.CLOSE_DT,"%mm/%dd/%yyyy") to avoid the error and error also gone but getting the below error now. Error message: ORA-01861: literal does not match format string from the oracle stage . The date from source coming as '08/20/2013' as char. ...

Never mind about your column delimiter. Read the whole record as one single column and split it up inside the transformer using field.

Can you give more info about your source? Are all your source columns independent? From your example I guess they are. If they are all independent, why dont you convert all your columns as records and filter out the unwanted records?

Is it not possible to make another copy of the job? If not maybe you can also simply create a dummy file 'running.txt' at the beginning of the job and delete it in after job sub routine. And use wait for file activity's 'wait for file to disappear' in either of the job sequence to determine the comp...

Why can't you use a User variable activity in between your job activity and notification activity and convert the status number into whatever you want?

I dont think that should be a problem. Your job should run fine and extract only the header data.

The detail records, if not found, should finish with zero count.

You have 1000 different record layouts but is your file a Fixed block file or a variable block file?

Check for the proper file name too.

If the file name is parametrized, it might not have the same file name/path in the job as it does in the job sequence.

You may need to verify those values before trying to view it.

I dont think it is possible to read VB file using CFF in server job but you can do it in a parallel job.

You have marked your job as a server job but posted it in parallel forum.