DSXchange

Hi,
Could any body tell me in what case is before/after sql used in OCI stage..any examples?

Thanks.

Thanks for the help.I had not updated my *.ora file..

Hi All, This question might seem simple but Iam very new to DS....plz help. I have a job in which the transformation is described like this: If Currency Decimal is 0 then 1, if 1 then 10, if 2 then 100 if 3 then 1000 if 4 10000 Does it mean that I have to write a DSTransform using IF THEN ELSE? Than...

Yeah,I can get the connection the service..outside DS

Hi,
Does anybody know about this error?
XXXXXX..ORAOCI9_8: ORA-12154: TNS:could not resolve service name
XXXXXX..ORAOCI9_8.DSLink1: DSP.Open GCI $DSP.Open error -2.
Iam getting this error when trying to view the data(using view data)in the source stage.
Thanks..

Can I do it in the same way even if all the tables source and target are in the same oracle database??

Thanks,I will try it and get back if any doubts.

Thanks Ray..
but the joining doesnt help due to the large amount of data.
Can I do it something like this..
oci1--Tr1--Target1
oci2--Tr2--Target2
oci3--Tr3--Target3
Any help?
Thanks.

Hi All,
Iam new to DS.I have a server job in which I need to combine 3 different oracle tables into one Oracle Target db.How do achieve this.any pointers plz..
Thanks a lot