DSXchange

Hi everybody, I am extracting two columns named SAMPLE_ID and TEST from an oracle table. Now i need to do a validation based on the condition: If SAMPLE_ID<>Previous_SAMPLEID or TEST<>PREVIOUS_TEST Then Sequence=0 Else Sequence=Sequence+1. Sequence will be a new column which i have to generate. Now,...

Hi all, can a lookup be done using two sequential files, i.e. one of them being the primary input and the other being reference. Is it not advisable to use two flat files to do a look up?

I have some ids like N000083100490420214001 in one of the columns.I have to parse through the id and if positions 2 to 20 in the above id are numeric then i have to map positions 2 to 4 in to an output column else leave the output column blank.How do i check whether positions 2 to 20 are numeric ......

Is LANGU marked as Key? Is it available in both the stream? What is the job design? ... Yes LANGU is marked as key. I am doing a change capture of two sequential files and after change capture i have a basic transformer because i want to change the default delete code '2' to 'D'. The target is a fl...

DSguru2B wrote:See if thispost helps.

DSguru, Thanks for the reply. I did go through the post that you have linked here. I tried all those but it still seems to not work.

Hi guys, i am doing a change capture for two flat files. The files have 6 columns. LANGU, INVTYP, PAYID, FROMDATE, TODATE and TXTMD. I have changed all the datatypes to varchar from char and date. When i run the job i have the following error. "APT_ParallelSortMergeOperator: Error when checking...

I need to caliculate the no.of days elapsed between two given dates which are in the format yyyy-mm-dd . I need to subtract the greater date from the smaller one to caliculate the no.of days between them
Can anyone please help me out on this...

After executing a query in sybase the value of one of the text column in the out put gave the following results <tagRoot> <CSTN_LAST_UPD_DTM>04/26/2005 16:30:43.276</CSTN_LAST_UPD_DTM> <CSTN_LAST_UPD_USID>i11317</CSTN_LAST_UPD_USID> <CSTN_CSCF_SEQ_S>0</CSTN_CSCF_SEQ_S> <CSTN_CSCF_SEQ_E>0</CSTN_CSCF_...

Could someone tell me as to how i can change the default value for the Delete Code in Change Capture stage. I want the Delete Code as D but it only accepts integers. Thanks

Does anyone have an idea of how to do an RFC load? Can someone tell me as to how i should go about it?

Thanks

DSguru2B wrote:Darn, next time maybe ...

Thanks guys. I have used eReplace as of now. Will try using other functions and update about it.

I_Server_Whale wrote:You can use Trim to that effect.

Code: Select all

Trim(InCol.Date, "-","A")

Whale.

Thanks Narasimha and I_Server_Whale. I will let you know about the result. Narasimha, yes all i want to do is remove the spaces.

Hi, i have a date field of the format yyyy-mm-dd. Now i want to convert it into yyyymmdd. I have tried using, OConv(IConv(link1.date,"D-YMD[4,2,2]"), "DYMD[4,2,2]") and got an output of the form yyyy mm dd. Can someone tell me as to how i can remove the space? Thanks

DSguru2B wrote:It could be YYYY-MM-DD, it could be MM-DD-YYYY. You need to tell us that. We will tell you how to get it converted. Actually the website will. ...

It is MM-DD-YYYY format. thanks

Such dates are not guaranteed to sort correctly. Convert them to internal format (or to YYYY-MM-DD format) and use these forms in your constraint expression. ... I have used Iconv too. Here is what i have written. Iconv(DSLink1.TERMINATION_DATE,"D/MDY(2,2,4)")> Iconv(DSLink2.ACTUAL_OPEN_D...