CFF Stage
Moderators: chulett, rschirm, roy
CFF Stage
I set up a CFF stage to grab is source data from a text file. I have the column metadata imported from the same text file. When I try to view data, I can see that the column lengths are correct, but the is no actual data. Any idea what might be causing this?
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
Re: CFF Stage
Perhaps I'm misunderstanding, but is the file layout AND the data in the same file ![Question :?:](./images/smilies/icon_question.gif)
If so, then the CFF stage is probably looking at the first line(s) of the file, which may be blank, or contain info from the file layout. Data and meta data have to be in different files.
Please expand your description of the issue.
Rob
![Question :?:](./images/smilies/icon_question.gif)
If so, then the CFF stage is probably looking at the first line(s) of the file, which may be blank, or contain info from the file layout. Data and meta data have to be in different files.
Please expand your description of the issue.
Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com
What is the size of your source file?
Why exactly are you using CFF stage?
Did you try accessing the file with seq. file stage? What happens when you do, dont worry about junk data, right now confirm if you are able to view it.
Also, make sure you are sourcing the correct file.
Why exactly are you using CFF stage?
Did you try accessing the file with seq. file stage? What happens when you do, dont worry about junk data, right now confirm if you are able to view it.
Also, make sure you are sourcing the correct file.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
the source file will be around 20,000 records. I'm using the CFF stage because the "business" wants it done that way. The whole process is set up through three jobs: (there may be unecessary steps)
ODBC (runs a create table statement in our DB2 database)
ODBC(runs the query and extracts from Oracle)--->transformer(trimming and such)--->seq.file to a designated location.
CFF(source is the Seq. File ) ----> DB2 bulk load
I'm sure there's a much simpler and easier, this is just the first thing to come to my mind.
thanks for the help
ODBC (runs a create table statement in our DB2 database)
ODBC(runs the query and extracts from Oracle)--->transformer(trimming and such)--->seq.file to a designated location.
CFF(source is the Seq. File ) ----> DB2 bulk load
I'm sure there's a much simpler and easier, this is just the first thing to come to my mind.
thanks for the help
If you have loaded the meta data for the stage (source columns tab), but have not chosen any columns on the "Select Columns" tab then it will return nothing as you are getting if there is lingering metadata. You can look at the destination column tab once the select columns tab is clear to see if there might be a lingering (hard to remove) column there. If so then this can cause your problems.
Also, make sure the data types for the columns are correct. Remeber the CFF does not read delimited files, rather a row is fixed width so make sure there are no varchar data types and make sure the width is correct. This means that the input file should be fixed width also.
Regards
Also, make sure the data types for the columns are correct. Remeber the CFF does not read delimited files, rather a row is fixed width so make sure there are no varchar data types and make sure the width is correct. This means that the input file should be fixed width also.
Regards
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com