DSXchange

Dear Experts I need to do address cleansing, the table is having different columns for address like HouseNumber, StreetName , Location, PostCode . The data in these columns is all mixed up, the following are some of the cases how the data is entered in the columns 1) In the HouseNumber column full a...

Convert('\n',char(10),ColumnName) Solved the issue......thanks every one

Hi I am loosing the format when I am posting it......so the format that I sent in my earlier post is not correct........my question is how I can replace \n with new line . One of the column is having the data which conatin \n which needs to be converted in to a different line........suppose if i got...

Dear Experts My requirement is like this In the csv file the record is like "abc","bbc \n xyz ", "efg" "abc2","bbc2 \n xyz2 ", "efg2" Then after loading in to the table the data should look like Col1 Col2 Col3 abc bbc efg xyz abc2 bbc2 efg2...

Dear Experts

Is it possible to email the Analysis Reports to send through Email in the Information Analyzer ? If yes how to do it ?

Thanks alot.............

Dear Experts

I got a requirement where I need to load the data from oracle tables to Siebel in XML format. How to do this ?

Your input will be much appreciated..........

Many Thanks

Sreenivasulu wrote:all the 5 partitions will have same data as the original dataset

Regards
Sreeni

Yes I know that what you and Chulett said, but what is the pupose of partitioning if it is the same set after partitioning?

Dear Experts In parallel jobs how does the Entire Partitioning property works, suppose if the data gets divided in to 5 partitions all the 5 partitions will have the same data as the original dataset . As the original single dataset is divided into 5 datasets is not a overhead itself, instead of cop...

chulett wrote:From Director, use the 'Add to schedule...' option. That will put it into cron and run it on whatever schedule you need. ...

Thanks very much indeed

Hi All

Is it possible to run a sequence at a given time , is it possible to set the time so that the sequence runs automatically suppose say after the midnight ? If yes how to do this ?

Many Thanks

Call an update script in an after job routine that only runs on job success. Thanks for the reply......my question was what lines of code that i need to include in the routine in order to connect to the Database......like DBName, UserName, Password etc.........how to write this in the routine apart...

Dear Experts I need to run an update script after the job execution. I tried using Stored Procedure stage but it don't have option for SQL server. Is there any way either to call a Stored Procedure from routine or writing the script in routine and then call the Database through routine ? If so can y...

You can achieve it in various ways. One of them is via Matches as Craig has noted. Sample If yourField Matches "0X'ABC'0X'XYZ'0X" Then .... Else ... ... Thanks very much for your quick response.....it is solved now....i used some thing like If InputColumn matches '...ABC...XYZ...' then 1 ...

Hi 1) select * from Employee where name like '%ABC XYZ%' 2)select * from Employee where name like '%ABC%XYZ%' In the second query there is extra % between 'ABC' and 'XYZ'. Similar scenario in DataStage i am using Index funtion for string comparion for the above case1 , i am using some thing like if ...

You can pass the invocation ID only to a down stream multi-instance job/sequence from start loop activity. Not when running the Parent job itself. Are you running that sequence manually 20 times or through script or other sequence? The job runs through sequence only for 20 times for the 20 values m...