DSXchange

Thank you everybody. I will check all alternatives and I will post here the results.

Hello intelcom, I did it and it solve my problem. Thanks.

Hello chulett, thank you for your reply. I tried to find here the solution before I posted this question, but in my case, I cannot create a calculation because in this column I have numbers, date, string. So I need to read without this conversion. Is it possible? If I open this excel I see the corre...

Hello Ray, because of that I decided to use this rule. In my data base there are rows with:

bla bla [0001]
bla bla {0002}
bla bla (0003)
bla bla [0004}
bla bla [0005)
bla bla {0006)

Thanks,
Igor Bastos Martins

Hello, on the weekend I didiscovered how to do it in a single rule. *& | & ="[", "(", "{" | ** | & ="]",")","}" | $ ;LIGACLIP CLIP TIT M BRANCO[200] COPY [3] {CodigoRef} RETYPE [2] 0 RETYPE [3] 0 RETYPE [4] 0 Thank you guys.

Yes, but my version does not support loop.

Thanks, to solve this problem I decided do that in SQL.

Thanks.

This is the IA Log the DataStage director log is very large. If you want I can put here. IA Job Status -------------------------------------------------------------------------- | Job Execution Status -> DPVAT_CHASSI77791107 | | JOB TYPE : com.ascential.investigate.ca.job.BaseProfileJob | | JOB PRO...

Hello, I am analyzing a very huge table and after 24 hours, it is failing with timeout error. Job run *FAILURE* in 1440 minute(s) 2 seconds. This error occur in more than one column, and always after 1440 minutes or 24 hours, so I would like to know if there are some way to increase this period. Tha...

Thank you, I will check this right now.

Thanks,
Igor Bastos Martins

Hello everybody, I am here aging needing help, this time with the Information Analyse. This week I am creating many analyses column from my tables and then I am creating 3 reports for each table analyzed. I have analyzed many tables but I need to analyze more than 300 tables yet. My problem is the I...

Hy Chulett, now I changed the job. I removed the stage stored procedure em put the stage ODBC Connector and te result was correct.

Thanks

Hi guys, I am creating a job to execute the procedure sp_who in my SQL Server. This is an internal procedure from SQL Server which show us many information such as spid, ecip, status, logingname, hostname, blk, dbname, cmd and requestid . In my first test I am using the stage Stored Procedure. The j...

Chandra, thanks for your reply, but why the above settings didn't work?

As I told I always did it and always worked.

Thanks,
Igor Bastos Martins

Hi guys, someone could help me? I need to do a JOIN, so I usually do this in two ways. 1. I select the patition type as Hash and I select my keys. I do this in both links (in the main link and in the reference link) 2. I select the partition type as Round robin in my main link and I select the parti...

Hi guys, I need your help. I know the function YearweekFromDate, this function returns the week number in the year from the given date, but now I need to know some function or logic that return to me the week number in the month. Following the example: September 2012 Sunday | Monday | Tuesday | Wedn...