Page 1 of 1
How to read redefines using parallel complex flat file stage
Posted: Mon Oct 16, 2006 6:57 pm
by umamahes
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
Posted: Mon Oct 16, 2006 9:22 pm
by ray.wurlod
Do you have a separate output link for each record type?
redifines
Posted: Tue Oct 17, 2006 10:50 am
by umamahes
YES I HAVE
Posted: Tue Oct 17, 2006 7:26 pm
by ray.wurlod
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.
Posted: Thu Apr 19, 2007 1:33 pm
by michaeld
You can't have more than one output link in a CFF. (except the reject link)
Posted: Thu Apr 19, 2007 3:18 pm
by ray.wurlod
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.
Posted: Fri Apr 20, 2007 7:57 am
by michaeld
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.
Posted: Fri Apr 20, 2007 4:11 pm
by ray.wurlod
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?
You can use the below mentioned functions
Posted: Sat Apr 21, 2007 8:30 am
by smrutiranjannayak
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 
Posted: Tue Jun 12, 2007 2:15 pm
by lfong
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.
I had some other problems
Posted: Wed Jun 13, 2007 6:04 am
by smrutiranjannayak
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 .