DSXchange

If I dont solve the issue we have other projects which we have not run the jobs yet, and I can not rebuild them all over again !
Thanks,

Recently we upgraded from V6.0.1 to V7.5. In my project there are 70 jobs which have sucessfully run except for one job which is no different from the others! This job extracts data from SAP R/3 using ABAP Extract stage and writes to a flat file. When I run the job it gives: 1)Warning : Unknown: DS...

Recently we upgraded from V6.0.1 to V7.5. In my project there are 70 jobs which have sucessfully run except for one job which is no different from the others! This job extracts data from SAP R/3 using ABAP Extract stage and writes to a flat file. When I run the job it gives: 1)Warning : Unknown: DSC...

Thanks Craig, got it !

Hi ,
Weekly we export all jobs to a .dsx file, now the issue is I need only one of the 125 jobs and how do I import that one job. If I have to import all the 125 jobs I am afraid it will overwrite all the other jobs which is scary!.
Thanks,

Ravi,
Did you compile the job, if you drag output from 3 transformers to the input of link collector, when you compile it says"LINKCOLLECTOR does not support active stages" !

Should it be In Process or Inter Process and how does it behave. How much should I select for buffer size.

But still I am thinking about the IPC stage not working and the reason for it.

Thanks,

The whole point is of making the job more efficient, and not use the files. I can concatenate teh files int eh same job but why to go for it when I am able to connect the transformers throguh IPC stage to Link Collector.
The issue is the link collector doesnt look like it is working.

I have used 3 IPC stages and then directly connected them to an Link collector and then to the target. The Issue is all the 3 transformers run fine and when the link comes to the IPC stage it just shows running. I stopped the job and increased the IPC connection time out to 999999. Still the job doe...

The IPC doe not support more than one input dude!

How would that solve the issue about connecting 3 transformers to a link collector. You mean use IPC in between the 3 ransformers and the link collector?

When I use Link collector and drag the 3 output links from transformers , when I compile it says , likn collector does not support active stages.

I did use append still when I use the files I get error saying required column missing when that particular column is nullable and not a key!.
So if I can avoid the files altogether and somehow link the 3 Xfms to the target.
Thanks,

Hi,
I have 3 transformers generating data with same metadata. Instead of staging it into 3 flat files and merge them and load into Target, is there a way I can avoid the flat files and merge the output of the transformers . I did use the link collector but it doesnt take active inputs!

Thanks

Hi Ray, I am using version 6.0.1 and in my job I have one source flat file, one ODBC look up, transformer and a target flat file. When I open the transformer stage, I have 3 link boxes. On the hash link when I right click or double click I donot find the "LinkProperty" option itslef!. Can ...