Page 1 of 1

Concatenation of 2 files (Funnel operator in PX) in Server

Posted: Mon Nov 27, 2006 5:27 pm
by Inquisitive
Hi All,

Hope you are all having nice time in Holiday season.

Can you please let me know how can I concatenate 2 filesin Server Ver on Windows Ver.

I have a requirement to read mutiple files which have same metadata and process them before loading into Target DB.

Note: Those files are generated by an earlier job, so it is OK if I can write DOS script which can concatenate those 2 files as after job routine or Script.

Thanks

Posted: Mon Nov 27, 2006 5:49 pm
by chulett
Using the type command and redirection or copy with wildcards or the append (+) operator.

Posted: Mon Nov 27, 2006 5:53 pm
by ray.wurlod
Execute the type or copy command as the Filter command in a Sequential File stage; the output link from the stage is fed from stdout of the command.

Posted: Mon Nov 27, 2006 6:29 pm
by chulett
I would have suggested that but have run into problems trying to use wildcarded cat commands in the Filter. Perhaps it works mo betta on Windows. :?