DSXchange

i did try that my stream is also of multiple keys but different
here my source and reference both are multiple keys
source primary keys are different from reference and i can join only one

Hi folks, :D Here is my question, I was opininion that if you use stream link and reference link, which means we are making an leftouter join(ie passing all values from stram link and matching rows only from reference link) But my data is like this, reference table is having composit key and the hen...

Yes i heard about using indexes, but never had an issue so never got to work with indexes, could kind of index i request the source admin to create fro me if i am using TableA Table B Table C and I am haveing join conditions as TableA.FilId=TableB.FileldId TableA.AddrId=TableC.addrId where TableA.Ag...

i totally agree with you, thats under process and it would take some time to upgrade, mean while I have to live with what it is right now and i got to extract data from 7.2 if any help to improve perforamnce issue will be greatly appreciated veen 50, 000 records or less taking more than 2.5 hours, i...

i totally agree with you, thats under process and it would take some time to upgrade, mean while I have to live with what it is right now and i got to extract data from 7.2 if any help to improve perforamnce issue will be greatly appreciated veen 50, 000 records or less taking more than 2.5 hours, i...

i am connecting to oracle 7.2 through DS 6 using ORAOCI8, if i use Read only trasncation isolation at my input, it throwing an fatal error unsupported network datatype or representation if i use reAD COMMIT IT WORKS FINE BUT VERY SLOW EVEN IF I CHOOSE ARRAY SIZE BIGGER PERFORMANCE IS NOT BEING EFFEC...

i am doing it at pluginstage

Hi all, I have a strange problem My source is oracle 7.2 and target sql, i am using datastage 6 and orcle 8 driver. when i tried perofrming any kind of conversion at input stage(Ora 8) say round or uppper or lower, it works fine and i am able to view data in new time but when i am transforming this ...

After establishing the business rule, as ofr ray said then it is easy to retreive first midle and last by using substring function and and with in the function again checking for space to by usnin index for example record as first name and ladt neme first name is retreived by UpCase(Trim(Substrings(...

Though The columns might be present in the Out put, you just Ignore them by not selecting corresponding data in the output stage, that means you are leaving them as null values by not loading any data.

Hello, Can someone point me to the correct usage of KeyMgtGetNextValue() routine. I see in the definition there is a parameter to this routine. How do we define this parameter? Do we have to pass a constant number value as the argument or is there a place to define the variables and pass that as an...

Did you try UpCase(trim(UR Input)="SUN"
Becase Datastage case sensitive and space validater

Ranga

i have Two colums, i have to generate second col val depending on first col value for example if col one values are as below col 2 values should be generated as belo col1 col2 A 1 A 2 B 1 B 2 B 3 C 1 D 1 D 2 any help? suggestions thanks ranga

Guys we need to full data from Oracle source 7.0, our team believes that DS 7 does not support Oracle 7.0, could some one suggest please but the catch other teams are using same server box to full data from oracle 8 and oracle 9, some one suggested ODBC but it still doent work, We dont want to go fo...

ririr,
thanks it works but many more thanks for Ray Wurlod who gave simpler code based on your logic, thanks to both you guys for your help
ranga