DSXchange

Thanks for your replay.

Correct me, if I am wrong.
But is SCD stage used for dimensions, then possibly for a limited number of row? I have to deal with a large number of rows.
Using SCD stage, is it possible to intercept fields that generate update operation?

Thanks again

Hi all, I have a question. My client ask to calculate difference between current data on DB and new data from a file, to decide if insert, update or discard data from file. So I need to simulate a sort of SCD of type 2, where a modify implies insert of new record and update of old record with valori...

I hope there was a way to acces directly to list.

Hi all,
I have a complex business requirement.
My customer uses Sharepoint application that runs on lists.

Is there a way to read this lists from Datastage job!?!?

Thanks in advance

Thanks, I find a solution.
I removed port number from address of config file, using only ip address + instance name...

Hi all, I have an odbc config file on a sun solaris server, used for IBM datastage. We need to connect to a sqlserver express edition. Ip used to connect is xxx.xxx.xxx.xxx\TARGET port is 1433, database is dbname . Sample of config file is: [T_TEST] Driver=/opt/IBM/InformationServer/Server/branded _...

I changed perspective for this task. Instead of wait for a dsjob launch to complete, I created a parametric shell script that launch dsjob command. I exec this script from another, and I apply wait command. It seems more clean and with minus code to implement for every check. What do you think about...

Hi All, I have a question. I want to run more instance of same job in parallel from within a script: I have a loop in which I invoke jobs with dsjob and without option "-wait" and "-jobstatus". I want that jobs completed before script termination, but I don't know how to verify i...

It's Info Mgmt - $230.00.

Hi all, I have a multiistance sequence that invoke multiistance parallels. Some times, it happens that an execution istance of sequence goes in error. If I search in log, I find that abort is due to a call of a job parallel: 1) It happens that job parallel istance goes, 2) sequence stays in waiting,...

Yes.
I hope I don't try exam again

Hi, I experimented that data mapped within transfomer from varchar to double seem to be truncated viewing that from ds viewer, but in sqlserver tables they are correctly conformed to input. By my experience, float sqlserver must be mapped to double (dfloat) datastage type. Otherwise if you map to fl...

Of course. #include <stdio.h> #include <stdlib.h> #include <ctype.h> #include <string.h> #include <time.h> char* AddMonthRoutine ( char* InDate, int AddMonths ) { if ( InDate == NULL || *InDate == '\0' || strlen(InDate) == 0 || strlen(InDate) != 8 ) { char rt[8]; time_t now = time(0); struct tm *d; ...

Thanks much.
I implemented a c++ function, compiled with options from administrator, linked *.o file whit a parallel routine: seems to be good.
In this way, I have basic and c++ version....

Hi all, I write a server routine to add months to a date. I have to use this routine in parallel job, inside a transformer, but it is not possible. I found that there are following solutions: *) use basic transformer, *) create parallel routine, using a c++ file in which make porting of basic code. ...