Column Import On Limited Part Of A Record

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ganive
Participant
Posts: 18
Joined: Wed Sep 28, 2005 7:06 am

Column Import On Limited Part Of A Record

Post by ganive »

Hi All,

Here is the deal :
I'm using "Column Import" Stage to divide a record (fixed length=600) into columns.

Example :
Line(600) -> Key (=Line[1,10])
-> Interesting Data (=Line[11,30])

I only need 40 bytes on the whole original record.
The Result of the "Column Import" is OK, I have access to every data needed in output, my field are loaded well.

My problem concerns the job execution. When I lauch the job, the director indicates Warning such as :
Ci_Entete,0: Import consumed only 32bytes of the record's 600 bytes (no further warnings will be generated from this partition)

Ci_Detail_Devise_Cours,0: Import consumed only 151bytes of the record's 600 bytes (no further warnings will be generated from this partition)

Do you know a way to avoid these warnings ?
If not, does this mean that when using "column import" you have to find in output every bytes you have on input ??

ThankS
--------
GaNoU
--------
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Just define a third column that contains the rest of the data in your fixed-length data and don't use the column. PX needs to know what it should do with the extraneous data and this is one way of handling that.
ganive
Participant
Posts: 18
Joined: Wed Sep 28, 2005 7:06 am

Post by ganive »

OK, Thanks a lot !!
I'm going to use filler in order to solve the problem.
Not so much fun when you have to select "unfollowing" data in a record (you have to define a filler between each data), but if it's the only way to work.
ArndW wrote:Just define a third column that contains the rest of the data in your fixed-length data and don't use the column. PX needs to know what it should do with the extraneous data and this is one way of handling that.
--------
GaNoU
--------
Post Reply