DSXchange

The issue is i have some other records too but i just want to strip KS1 and OR records only Source COL1 KS10000000200001 KS1000100001 OR00000002000078 OR000000020000789 NVL00000002000078 COL 1 will be mapped to three columns in target col1_ks1 col2_or col3_other 200001 20000789 NVL00000002000078 100...

This will take care of KS1 what about OR then

how can i remove first three chracters?

Hi,
I have column AA1 which looks like
KS10000000200001
KS1000100001
OR00000002000078
OR000000020000789

i want to Remove KS1 + leading 0s and write 200001 and 100001 in target and same for OR00000002000078 Remove OR + leading 0s

Target should be
200001
100001
2000078
20000789

ok i am updating in database now so i put below sql in after sql it runs in datbase but i get below error The OCI function executeDirect returned status -1. Error code: 1861, Error message: ORA-01861: literal does not match format string. (CC_OraUtils::handleBeforeAfterSQL, file CC_OraUtils.cpp, lin...

Thanks for fishing comments
i did try below and it worked but when i query database data is coming like 09-12-31
If DSLink77.ANLA_AIBDT = '00000000' Then setnull() Else StringToDate(DSLink77.ANLA_AIBDT,"%yyyy%mm%dd")

Data comes in as 20091231

getting warning now

If DSLink77.ANLA_AIBDT = '00000000' Then setnull() Else StringToDate(DSLink77.ANLA_AIBDT,"%yyyy-%mm-%dd")

TFM_ANLA,1: Data string '20091231' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %dd.

HI, i am getting below error while doing StringToDate(DSLink77.AAA,"%yyyy-%mm-%dd ") Error: Data string '00000000' does not match format '%yyyy-%mm-%dd ': an integer was expected to match tag %dd. Issue is some data is good(20110302) and some is not (00000000) and we need to convert this f...

Hi,
I am doing stringtotimestamp transformer not liking it any idea why.

StringToTimestamp(DSLink77.AA,"%yyyy-%mm-%dd %hh:%nn:%ss"%)

Hi, I have column year datatype varchar which goes in to column date datatype timestamp and i am getting errors how can i convert varchar to timestamp keeping the same format so Source (Varchar) Target(timestamp) 2004 2004 2005 2005 I am using transformer for conversation

Hi, How can i do below in datastage 8.5 Thanks, When extracting table information from SAP into Dataset, we should know how many records (rows) have been extracted from the SAP table and how many records have been writen to the Dataset table. Likewise, when the information is processed into the Stag...

Hi, I have record coming as below in txt file "123", "T120 20" TFT Monitors" ,"KBC" "234"," My name is sam","ABC" i want to double code to be doubles something like below See double quote after "20": "123", "T1...

Hi,
I have data like this 'F1', 'F34','JACK','NULL', 'ROB'
i want to do transformation only 4 letter string so in target it should look like 'F1', 'F34','JACK','NULL, 'ROB'

how can i do it

Thanks

Hi,
Currently we extract from Oracle and db2 databases going forward we need to extract from SAP HR i am looking under Database palette can't see any SAP database so how we connect to SAP databases then?


Thanks