file column name mixed up when files number is greater nodes

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
mdan
Charter Member
Charter Member
Posts: 46
Joined: Mon Apr 28, 2003 4:21 am
Location: Brussels
Contact:

file column name mixed up when files number is greater nodes

Post by mdan »

Hi,
I wonder if anyone got this strange behavior:
I'm reading the files using the File Pattern as Read Method and File Name column in order to get the file name. It reads all the files correctly (about 500 in the original job - 5 in this example), but in the file name column I got only one file name per node (the testing configuration has 4 nodes - looks like I'm getting the last file name per each node).

Code: Select all


simple job
SeqStage -> Copy -> SeqFile

e.g.
files TEST01 to TEST05
each file content is related to the file name (ONE -> TEST01, ...)

result
TWO,/PATH_TO_FILE/TEST02
FOUR,/PATH_TO_FILE/TEST04
THREE,/PATH_TO_FILE/TEST03
ONE,/PATH_TO_FILE/TEST05
FIVE,/PATH_TO_FILE/TEST05
Thanks,
Dan
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Can you post the code entered in "File Pattern" property?
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Set APT_IMPORT_PATTERN_USES_FILESET to True and try. If this didn't work you might have to get a patch from IBM for fixing this issue. Been discussed this before here.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
mdan
Charter Member
Charter Member
Posts: 46
Joined: Mon Apr 28, 2003 4:21 am
Location: Brussels
Contact:

Post by mdan »

JoshGeorge wrote:Set APT_IMPORT_PATTERN_USES_FILESET to True and try. If this didn't work you might have to get a patch from IBM for fixing this issue. Been discussed this before here.
Thanks,
I've seen the post. Looks like I have to go for that patch ...

regards and thanks,
Dan
Post Reply