read multiple files using sequential file,

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
ds_teg
Premium Member
Premium Member
Posts: 51
Joined: Tue Aug 11, 2009 6:53 am
Location: Chicago

Post by ds_teg »

use file pattern and after that extract filename the file . Use this filename in transformer constraints to segregate the records ..in derivations use these n add another column ..
saiballa1
Participant
Posts: 2
Joined: Sat Jun 04, 2011 1:55 am

read multiple files using sequential file

Post by saiballa1 »

Thank a lot for ur reply.

Could u pls explain in detail... im new to DS
saiballa
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Which part is unclear? Always best to ask specific questions.

First ensure you can read multiple files, have you tried using the File Pattern yet? Also there is an option in the stage to add the filename as a field, enable that. That way you can check the value in a transformer to decide how to populate the derived field you add there.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply