DSXchange

Thanks.It worked.After 1st step i did substring logic in transformer.
I am going to mark this as resolved.

The data i have posted above is sample but date fields are always just two.

Is there any way we can handle this situation in datastage.

This is the finest list and we are using same order.

Is there any way that we can read read xml file where tagnames coming with same name.i am able to read first XML and populating fields except updatedate fileds.here i want to ppopulate if dateSequence=0 then updateDate should go to firstdate and if dateSequence=1 then second updateDate should go to ...

you have to ridoff special characters prior to read XML file by creating Before/After subroutine. Ans = '' if len(ARG1) > 0 then for i = 1 to len(ARG1) if ( 033 <= (seq(substrings(ARG1, i, 1)))) & ((seq(substrings(ARG1,i,1))) <= 125) then Ans = Ans:(substrings(ARG1,i,1)) end else Ans = Ans:' ' e...

Sparse lookups should be used in the case of the input data being significantly lesser than the reference data. This will fire a query to the database for every input record and hence would be performance issue for increased number of input records. The Join stage uses hardly any memory at all. It t...

Here is the complete code #include "iostream.h" #include "string.h" #include "stdlib.h" char* PrStrRep( char *InStr, char *SubStr, char *Replace, int Occurance, int Starting) { char *result = new char[2000]; size_t newlen = strlen(Replace); size_t oldlen = strlen(SubStr...

it worked for men now for huge records by removing malloc and replaced with dynamic array. #include "iostream.h" #include "string.h" #include "stdlib.h" char* PrStrRep( char *InStr, char *SubStr, char *Replace, int Occurance, int Starting) { char *result = new char[2000...

can any post your thoughts here.

Hi i tried below routine which suppose to replace string with given substring but and i have an issue with this.i am ble to process less volune of records(ex:1000) and when i ran with huge volume(ex:15 million)of records it is hanging and keep running never finished and no warnings.is there any buff...

here is the program i tried and it is not working for huge records.i appreciate for any suggestions. #include "stdio.h" #include "string.h" #include "stdlib.h" char* pxEreplace(char *str, char *subStr, char *rep, int num, int beg) { char *result = (char *)malloc (sizeof...

Hi i tried the above routine and i have an issue.i am ble to process less volune of records(ex:1000) and when i ran with 15 million records it is hang and no warnings.is there any buffer issue in this c program

what exactly i have to give in expression editor in UserVariables stage.

example:
file contains list of filenames

Filenamelist.txt
----------------
file1timestamp.txt
file2timestamp.txt