DSXchange

But IBM's CDC license will Cost seperately, right? i need to enhance the job with the server edition alone.

Yes, I need to bring all the Coulmns from Source to target.

My Source is Oracle and my target is also Oracle, but both are in different servers. In one of the source table, we have around 200 Columns and the data is also huge (around 7 Million). We need to extract the data incrementally, and we dont have timestamp column to identify the newly inserted or mod...

interview question?

Might be your target table is locked, Check for any locks on your target table and release it.

Based on the design, it seems you are using Peoplesoft Delivered Jobs, why cant you raise a case with your official support?

What do you meant by 'BLANK'? Is it Null or Empty String ?

Will your target accept NULL values for that date column, in that case use @NULL in your Transformer derivation.

You have to execute this from Administrator Command Prompt. Convert the query to a single line and execute it.

Or Else, create a job and use this SQL in the universe stage and pass the output to a file.

There is no existing one for getting all the where clause used in the jobs.You need to get it from DS_JOBOBJECTS and it will vary based on your DB Stage. The following query will list all the User defined SQLs and Where Clause used in a DRS Stage, like that you have to write it on your own for your ...

Thanks for the replies, and i am able to echo the environment variable values. But I used the function , which is provided by Ray in some other posts. FUNCTION GetEnvironmentVariable(EnvVarName) If UnAssigned(EnvVarName) Or IsNull(EnvVarName) Then Ans = @NULL End Else Call DSExecute("UV", ...

Sorry, If i didnt make it clear. I want to read the project Parameter and not the Environment Variable.

Reading DSParams is a good idea, but my boss is suspecting, that this action may corrupt DSParams file. Is there any thing similar to PX's GetEnvironment for the Server Edition or is there any other way to get it. I know the environment variable name, and it will be constant , so inside the jobcontr...

I have a requirement, to get the value of project level userdefined environment variables inside a jobcontrol or routine. I know the easiest way should be declare all the required parameters as job parameters and we can access it inside the job control. But I dont want it to be defined in the job pa...

Hi All, I have created a hashed file in the Account path, and when reading the output from the Hashed File, the Selection tab (in output tab) was available and i have some selection criteria there. Now, i need to create those hashed file in directory path, these are the steps i did. 1) Delete the cu...

Ray,

You have told about Column Level impact analysis, in the webinar. if we have license only for Datastage, whether we will be able to access this information or do we need to get Metada Work bench license for getting this information?

I think the new user dont have rights to access the clent path, where oracle is installed. Are you able to connect through SQL+ by using new user credentials?

You can do this at the database itself. SELECT LA,VOL1,DATE,VOL2,VOL3,STAUS,dummycol FROM ( SELECT LA,VOL1,DATE,VOL2,VOL3, STATUS, 0 dummycol FROM YOUR TABLE UNION SELECT SUM(LA),SUM(VOL1),NULL, SUM(VOL2), SUM(VOL3),NULL,1 dummycol FROM YOURTABLE ) dummytable order by dummycol I dint tested it, take...