DSXchange

Guyz,

I need to encrypt the data coming from source(Database table) and load in to another Database table. The data is 'SSN'.The source has all the 9 digits displayed.The transformation is, I need to mask the first 5 digits and display the last four only....any advices.......


Thanks,

Excuse my ignorance.How can I keep 'tab' as delimiter.Should I mention 009 in default padding section.

Thanks,

I'm doing an initial load Here is what I have done. Source has 18.6 million records. Method 1 : Job1 extract to file (success) Job2 Load from file (Failed) lots of warnings and rejects Error message :Inserted value too large for column, row rejected. ORA-01722: invalid number. I used the same meta d...

Folks, I have a master sequencer that calls 5 sequences in that job.The job runs fine every night in prod,but Yday it failed.The reason is the master sequence is not able to call the one of the sequence contained in it. This was the message jsParent (@jschild5): Controller problem: Error calling DSR...

Thanks for u r response jgreve,

i will give a complete logic for that by the end of the day.


please help me.


Thanks in advance.

Hi folks, i have a source column A of datatype numeric of length 6 and target is also numeric of length6 The logic need to be applied for this field is when the source record value is -ve then it represents the age>80 with respect to that we need to add the Century for that value. Please help me wit...

Thanks kumar,

Appreciate your help.

Hi,

can any one please provide the pdf document of orcherstate manual

for complete understanding of Datastage parallel extender functions.

Please help me, because i am new to PX and i am little bit confused.

Thanks in advance.

Thanks for the response Ray,

i searched for the orcherstate operators manul in Datastage EE guide provided by Ascential, it is not there.

Please provide more information where it is available.


Thanks in advance.

Thanks guys for your response.

Hi, i am new to Enterprise edition, i know the functions that are used in Server jobs Ex:- OCONV,TRIM,LEN. is these functions are same in EE, or is there any difference Please help me in this. If there is anything new Where can i find all the functions that are available for EE. thanks in advance.

Atleast please make u opinion based on your experience working with DS server or EE to Informatica.

Recently we had Proof of concepts for DS and Informatica.I'm a DS consultant and I'm in favour of DS(Hawk).But I need to convince other team members that DS(Hawk) is more effective tool than Informatica.So inorder to do so, I need your support.Please post your valuable experience in support of DS h...

Hi , i am using userdefined SQL for the UPDATE ACTION, the function of the userdefined sql is it inserts the data into the table, i am adding more columns to the existing job, i mean it is a new column as per the business requirement, here i need to use update action as insert (or) update. give me a...