How to read redefines using parallel complex flat file stage

umamahes · Post by **umamahes** » Mon Oct 16, 2006 6:57 pm

I am having problem in reading redifines in complex flat file stage in parallel job so can any body help me in resolving this issue

I appreciate for that

ray.wurlod · Post by **ray.wurlod** » Mon Oct 16, 2006 9:22 pm

Do you have a separate output link for each record type?

umamahes · Post by **umamahes** » Tue Oct 17, 2006 10:50 am

YES I HAVE

ray.wurlod · Post by **ray.wurlod** » Tue Oct 17, 2006 7:26 pm

So what, precisely, is the problem that you are having? Is the metadata on each output one of the redefined table definitions? Are you getting any error messages logged by the CFF stage? If so, please post the exact text.

michaeld · Post by **michaeld** » Thu Apr 19, 2007 1:33 pm

You can't have more than one output link in a CFF. (except the reject link)

ray.wurlod · Post by **ray.wurlod** » Thu Apr 19, 2007 3:18 pm

You're right. The good news is that you can (have multiple output links from a CFF stage for each record type) in version 8.0.

michaeld · Post by **michaeld** » Fri Apr 20, 2007 7:57 am

Ray, is there any way to do it in version 7.5?

Right now I just write all records that don't match the schema to a reject file and then read the reject file as a source to get the records for the second schema. I have two schemas. So I end up with two jobs.

I don't like this approach, but I can't think of anything better.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 20, 2007 4:11 pm

Could the rejects link from the first CFF stage be directed into a second CFF stage (or even a Column Import stage) to handle the other record type in the same job?

smrutiranjannayak · Post by **smrutiranjannayak** » Sat Apr 21, 2007 8:30 am

Hi even once i faced the same scenario once

One way is CFF stage but i dont have much clarity on that....

I followed the alternate sequential file stage .

i.e , Use the data as a bunch for which you have redifinition and slice it accordingly as per your requirement .

Means if you have column position from 1 - 50 . The same bunch has been used twice or more by some other columns but with different data type .
So group this data into a stage variable and slice it cordingly each time.....

Cheers

lfong · Post by **lfong** » Tue Jun 12, 2007 2:15 pm

Could you not use the CFF stage into a transform stage. The transform stage would have have multiple outputs. Use constraints for each record type for each corresponding redefined definition.

smrutiranjannayak · Post by **smrutiranjannayak** » Wed Jun 13, 2007 6:04 am

Hi ,

The problem i am facing is :

The input file is not a fixed width file ( its a cobol data file )

I used CFF stage also to read the data means view the data.....i have some redifines and occurs clause .

So i am not able to do that .

Also suggest how to use redefines tab in CFF ( gurus pls answer) in case i am using more than one columns for redefined .

Can we do any individual column settings ??

Please advice .

DSXchange

How to read redefines using parallel complex flat file stage

How to read redefines using parallel complex flat file stage

redifines

You can use the below mentioned functions

I had some other problems