DSXchange

Sorry if my context was not good.I meant all the mebers in the forum to help me out..

Hi,

I have an issue in reading the file which comes with

A"|"B"|"C

"|"as delimter it has the quote on it, long time on files so need ur help on handling it.

Tried using ""|"" did not work.

Thanks,
RK

As ray said no enough info,is your i/p is comma delimited file with four columns?

Any thoughts???????

Thanks Ray!!!

Ray,
I found it comes as like this in 8.5

StageNames "Seq|Seq_1|Aggregator_2"
StageTypeIDs "PxSequentialFile|PxSequentialFile|PxAggregator"

thanks for your help.

Is there any way we can get the stage type in dsx.for ex in a simple job if we design a simple seq file--->xfrm---datset.will i get any info on the dsx that i used seq file stage,transform and datatset.Not the stage name,i may give seq for dataset but i need the type of the stage as dataset.i am see...

Un-hijacked. your are correct craig, sorry about that for not making it a new post i though that would be more clearer. Sorry, but it never is. All it does is distract people and confuse things when two problems are being discussed in the same thread. That and you have no mechanism to mark things a...

Consider few things while use SCD stage. 1. SCD stage will give two out puts. 1 is to update the DIM table and the next out put is to FACT table Or other DIM table. 2. In Fast path step 1 you will have the option for Select output link. You need to decide which link you need yo use to update the di...

I did exactly like urs and i have a surrogate key id i put it as surrogate key and the natural key as business key and rest of the columns as type2. in dim update i ahve given as urs.but it is inserting and in the oracle stage i have given natural key as key.in the director am getting lookup table e...

chulett wrote:Un-hijacked.

your are correct craig, sorry about that for not making it a new post i though that would be more clearer.

I have used SCD stage as mentioned in this postand i have included the surrogate key also in that, in the surrogate key tab i made it as from DB sequence.it is inserting properly but it is not updating rather it just adds one more new record am i missing some thing.

I have been through this before and checked with the space as it was alright, the option i went in to delete the Dataset through commands and recreate them it went through fine.

I think the problem is with your Dataset,it got corrupted so Please use the Orchestrate command to delete the dataset and recreate them by running the same job.

There's no need to convert....the jobs will still work "as is" with the Plugin...and if you were using the plugin, you were using MQ Server because the Plugin never supported MQ Client.... ...is your MQ Server co-resident with DataStage....then use MQ Server. Ernie You are right Ernie i a...