DSXchange

Ray, looks like Index() take three params...Index (string, substring, instance) and you have four in there..

Can you please explain why you want me to add below one to over all logic?

Index(Sequence, ",", 1) = 0 Then

Thank you Ray & Craig for quick response. Ray, you are right, I want to concatenate. Is there any way to handle varying count in sequence col, I mean, I can have two sequences in row-1 and four sequences in second row? Or do I need to code for Max no. of Sequence and then trim '~'? Thanks, Thank...

I want to split values in column CODES and produce output based the numbers/order listed in 3rd column SEQUENCE. Below is an example of input and output I need to produce. Please help to find a solution for this. Input: Num|Codes|Sequence 101|a,b,c|2,3 102|m,n,o,p|3,4 103|x,y,z|3 Required Output: Nu...

nsd,
were you able to configure IIS Manager with Subversion using Eclipse?
If yes, would you please post the high level steps on how to do it.

thanks
Anu

Can IIS Manager and Subversion be configured to talk to each other? In my earlier assignments I ahve seen IIS Manager talk to ClearCase.

thanks.

Thank you all for the inputs.

planning to meet DBA group to discuss further on this.

Craig, you are correct. If the source table is not indexed then probably I see same issue even with delta pulls.

Like I said, we are planning to meet DBAs and will keep you posted.

Thanks again.

Prasanna, No stages in between. we tried that approach and found better performance. Craig, I think there are some network issues as well. Source, Target and DS Servers are located at different locations with limited bandwidth. Indexing, I am not it's a good idea to ask them to create indexes on suc...

One of our jobs is running for ever to extract from an oracle table which has nearly 10 bil rows. We are trying to do an initial load to target i.e. Netezza, but it is running for ever. So, We tried to pull for a date range of 3 months or so, the job ran for 10 hrs to pull 300 mill. row. It is very ...

Hi Ray, I found the info from the link below and tried by changing the field type as nvarchar in DS and not changed in the table , so that could be a reason for failing again with same error . "To resolve this issue, you can triple the original varchar precision and size, or you can change the ...

I am reading from .txt file and trying to load in to DB2
We have NLS as UTF-8

Error : [IBM][CLI Driver][DB2/AIX64] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use. SQLSTATE=22001

Yes , i want first 50 positions of a 100 character string. I tried with substr & [1,50], but its not working.

Hi All,

Is there any function or method we have in DataStage to truncate the value of Chinese Char from 100 to 50 ?

Please suggest me .

Thank you Ray. I am thinking to have a generic datastage job to compare row to row and then another program ( may be a UNIX script) to further compare at column level.

-Thanks

Thanks Ray.

I have tried that and in that case for example
One out of 100 columns is not matching that
Row will end up in mismatch report

So validatiob team need to spend lot tine
again To verify which out o 100 columns is not matching

I have a job which does compare two input files and produces output reports. My design is inputfile1 and inputfile2 feed into a difference/cdc stage and based on the diff/change code, I route the records to respective report. This is working fine for us. I want to make this more generic so that I ca...