DSXchange

I had used YEARFROMDATE(SYSDATE-DATEOFBIRTH) gives the desired output..
Thanks a lot guys

ray.wurlod wrote:... Convert() uses fewer resources than Ereplace(). ...

Hi Guys..

It worked out. Thanks a lot

ArndW wrote:Why not just "LEFT(In.InputColumnName:STR('0',50),50)" - simpler and uses somewhat less CPU? ...

It woked out. Thanks a lot :D

Govindarajan wrote:How do you define this first 25 rows? based on any key column or date and time of record creation?

Yes it is based on a Key Column FTRJ, which is a string..

ArndW wrote:What format and datatype is "Date of Birth"? And is "age" an integer number of years? ...

Date of Birth is String and Age is years

Hi, My requirement is such that I need to append zeros with my input file. The output length is 5. I might get an input from 1 length to 5 length. Say the input 'ABC' (length 3) Input='ABC' Output='ABC00' Then my output must append two zeros. length of input is 4, then 1 zero needs to be appened.. '...

I have input in which the Date of birth of customer is given. I need to find the respective age and populate that in my target. How do I achieve this..

Age= Current Date- Year of birth.. How do i go about. is there any inbuilt function for this. Kindly help

My input is something like this: Input:'ABC DEF GHI' Input string has few spaces in between, and I want the output in such a way that Zeros come in everyblank space. All the spaces need to be replaced by zeros Output shoud be: 'ABC00DEF0GHI'. Should i have to use transformer to achieve this? And is ...

Hi,

My requirement is such that the 1st 25 rows of oracle needs to be deleted everytime I run datastgae job to load Oracle. How do I achieve this?

"do not check point" Check points are used during run time of sequencer. If say fifth job in the sequencer fails and you want to start the sequencer from the point where it is failed then u should give "Check Point" If u dont want this to happen and start the sequencer from the f...

When you use Upsert Option then, it will prompt you to decide which one to do first-> Either Insert or Update If record exist 'Update' or 'Insert' Try giving both Insert and Update statement in the Ora Stage Update COLUMNS WHERE CONDITION INSERT INTO TABLE VALUES(..) Even if it doesnt work dont do U...