CAT Command

vijaykatneni2 · Post by **vijaykatneni2** » Tue Sep 11, 2007 10:50 am

Hi,

Can any one help me how to concatenate the text files in datastage without using CAT command.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 11, 2007 4:04 pm

Two jobs. One overwrites the file. The next appends to it.

vijaykatneni2 · Post by **vijaykatneni2** » Wed Sep 12, 2007 11:15 am

is it possible to do within one job.

[quote="ray.wurlod"]Two jobs. One overwrites the file. The next appends to it.[/quote]

Minhajuddin · Post by **Minhajuddin** » Wed Sep 12, 2007 12:02 pm

You can use the funnel stage for this.

vijaykatneni2 · Post by **vijaykatneni2** » Wed Sep 12, 2007 10:19 pm

Yes,we can but the problem is the files has different metadata.

[quote="Minhajuddin"]You can use the funnel stage for this.[/quote]

Raghavendra · Post by **Raghavendra** » Wed Sep 12, 2007 10:37 pm

You can still use two jobs, one overwrites the file and the other appends to it as ray said.File name should be same in both the jobs.
If you don't want to use it then you have to use funnel stage by adjusting the metadata of one file to synchronise both files metadata.
Otherwise you can concatenate all the columns of the file into single column for both files and can use a funnel stage.

Just curious to know why you don't want to use CAT command to concatenate the files.

Raghavendra · Post by **Raghavendra** » Wed Sep 12, 2007 10:39 pm

You have used a wrong forum to post your question. Please post the query in the correct forum going forward.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Mon Sep 24, 2007 4:56 pm

Moved to PX Forum