DSXchange

I guess u may have to commit for each insert in the dimension table and then updated the hash file with the current data from dimension table but not the history data. So we you get the same record, it will look for the hash and will find it and then makes an update for existing record and inserts t...

Thanks Guys

Hey craig,
Thanks. I havent thought, but i was thinking do we have any function or transform to do it.

Hi ,
I have a string of values from input and i would have to say,if 000,010,020 then 'A' else if 022,033,040 then 'B' and so onnn. I was wondering do we have any easier way to do this, instead of IF THEN ELSE as i have 85 values coming in.

Thanks

Hi pavankvk, Basically you can unlock the jobs by two ways: 1) As kool78 said you can release or unlock the jobs from Director. 2) In Administrator, at command line go to DS.TOOLS and select option 5 and enter the pid of the job to release. I consider these to be the safe methods, instead of killing...

Hi,
I am trying to call Sequence from Database to generate a key in the datastage. Please advice me how to call a sequence in datastage. I am not refering to JOBSequence.

Thanks in advance.

Hi,
It worked by giving group by in SQL.

Thanks Guys

Hi,
I have two records source with same keys but the only difference is the Date field. And i need to pick the record which has a max date and ignore the other record.

Please advice me.

Thanks In Advance

iwin, You could try filtering all characters that have a value of greater than ASCII (x7F). Those are generally considered the 'special' characters that can cause grief in downstream processing. http://en.wikipedia.org/wiki/Ascii Rob W. Hi rwierdsm, Thanks for your advise. Can you please explain me...

Hi ,
I am trying to select a column which has weird character at the end of data. Can anyone help me how to select only the corrected data.

Ex: 1234@

Thanks Inadvance

kcbland wrote:Per the user's requirement, the polarity of the percentage doesn't matter:

Code: Select all

If Divisor = 0 Then 0 Else Dividend/ABS(Divisor)

Hi Kcbland,
I got the result i wanted with the above code. Thanks a lot.

If Divisor = 0 Then 0 Else Abs(Dividend/Divisor) Thanks for the reply ray. But i think my question is not clear. Actually what i am trying to do is divide A by B such that if A and B are both -ve then the result should be a -ve value and if A is -ve and B is +ve or A is +ve and B is -ve then the re...

You get 2 because the laws of mathematics dictates that is the answer. Two negative numbers multiplied together always produce a positive, and division is the same. If you don't like your answer, just multiply by -1 whenever you need to change polarity. Hi, Thanks for the reply. Actually i have two...

Hi,
I am trying to divide -20 by -10 and i need the result to be -2 as i am calculating %. But it is giving me 2. Please let me know what function should i use.

Thanks in advance

Hi, I am trying to select records based on date field between 01/2004 - 12/2004 in oracle. I tried using the following UserDefined SQL but its not working. SELECT * FROM ACCOUNTS WHERE TO_CHAR(EFF_START_DT,'MM/DD/YYYY') >= '01/01/2004' AND TO_CHAR(EFF_START_DT,'MM/DD/YYYY') <= '12/31/2004'; Thanks i...