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

Inquisitive · Post by **Inquisitive** » Mon Nov 27, 2006 5:27 pm

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

chulett · Post by **chulett** » Mon Nov 27, 2006 5:49 pm

Using the type command and redirection or copy with wildcards or the append (+) operator.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 27, 2006 5:53 pm

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.

chulett · Post by **chulett** » Mon Nov 27, 2006 6:29 pm

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.