DSXchange

Using CurrentTimestamp() Function i am getting output like
2007-06-25 10:37:14

But i need to Populate this type of fotmat : 20070625 10:37:14 .How to get this format.

Thanks

I need to findout most recent salary effective date. For based on Emp no,Effective Date,Salary. Emp no Eff Date Salary 100007 ^ 1999-11-01 ^ 000000000002152.57 100007 ^2000-11-01^ 000000000002152.57 100007 ^2001-01-01^ 000000000002152.57 100007 ^2001-11-01^ 000000000002152.57 100007 ^2002-11-01^ 000...

Hi, I need to findout most recent effective date. Emp No Date Salary 100007 ^ 1999-11-01 ^ 000000000002152.57 100007 ^2000-11-01^ 000000000002152.57 100007 ^2001-01-01^ 000000000002152.57 100007 ^2001-11-01^ 000000000002152.57 100007 ^2002-11-01^ 000000000002152.57 100007 ^2003-04-01^ 00000000000215...

Yes...

1234 01-02-2007 4500

Hi,Ray
I understand i have to use Transformer Stage and also i have to create stage variables to keep checking present and prevoius salaty's.Before Transformer i have to do Hash partioning baesd on Keys columns.

Can you Please go through the in depth...How to do

If i have above columns.


Thanks

whatever you specified logic will work previous examples. But for particular employee demotion also will happen.How to implement below condition also. I need to Backtrack recent salary Effective date. Emplid EffDate Salary Monthly 1234 02-02-2001 3000 1234 01-12-2006 4500 1234 01-01-2007 5000 1234 0...

whatever you specified logic will work previous examples. But for particular employee demotion also will happen.How to implement below condition also. I need to Backtrack recent salary Effective date. Emplid EffDate Salary Monthly 1234 02-02-2001 3000 1234 01-12-2006 4500 1234 01-01-2007 5000 1234 0...

Emplid EffDate Salary Monthly 1234 02-02-2001 3000 1234 01-12-2006 4000 1234 01-01-2007 4000 1234 01-02-2007 4000 For a praticular employee I need to find out like Present salary has to be compared with previous salary. If salary is same then I need the previous eff_Date i.,e 01-01-2007 & also c...

Hi, DECODE(job.empl_status, 'D', TO_CHAR(NVL(pers.dt_of_death,job.effdt),'MMDDYYYY') ) Descease_Date, Iam supposed to do the above function in datastage, plz let me know if it is correct or not which is shown below?? Iam doing this in transformer If job.empl_status < > 'D' Then NULL ElsIf job.empl_s...

StringToDate(svYear : "-" : svMonth : "-":"01")

Month 2 digit, Year 4 digit

It still giving me ******

Thanks

Iam doing this in transformer

StringToDate(svYear:"-":svMonth:"-":"01") (datatype date)

svYear is YearfromDate(RUN_DT) (datatype integer)
svMonth is MonthfromDate(RUN_DT) + 1 (datatype integer)
But the above one is still showing as *******

Thanks

YearfromDate(RUN_DT):"-":svMonth:"-":"01" (DataType is Date)
where
svMonth is Month + 1 (DataType is Integer)
RUN_DT is 2007-01-01
Output column is giving is *******.

Thanks

Hi, I need to calculate the end date of the month. i.,e If i give the date like 2007-03-14, it should give me 2007-03-31. I need to do this in transformer. DateFromDaysSince(-1, StringToDate(DateToString(RUN_DT, "%yyyy-%mm-%dd"), "%yyyy-%mm-%dd")) Above code works for previous mo...

Hi, I need to calculate the end date of the month. i.,e If i give the date like 2007-03-14, it should give me 2007-03-31. I need to do this in transformer. DateFromDaysSince(-1, StringToDate(DateToString(RUN_DT, "%yyyy-%mm-%dd"), "%yyyy-%mm-%dd")) Above code works for previous mo...

StringToDate((YearFromDate(CurrentDate())-1):"-12-01", "%yyyy-%mm-%dd")

The above 1 works for me, Thanks for all