DSXchange

I have not tried it. But what I can say is same configuration on DS7.5 gives different output and in DS8.0 it gives different output count. I am not sure why??

Well, I added one more property in the sample stage and output seems to be going closer now:

I added property: Seed = 1 and now the Output Row Count is 13077 which is much closer to the expected count.

What is the significance of this property and how does that affect the output count?

All, I have a job in which I am sampleing records using a Sample stage. I am using Percent mode to sample the data. Below are the properties I have set: Percent = 5.0 Sample Mode = Percent Input to Sample Stage: 261444 Rows Output Of Sample Stage: 12895 Rows Expected Output : (261444*5/100) = 13072....

Oops. Thanks for the reply.

Yes its from NVarchar(120) to Decimal 8
I am sure the source data will hold not more than 8 chars from the source based on one filtering criteria. How do we eliminate the warnings it throws any due to this.

Thanks

dscmdexport helps to take dsx export only, there is no funcationality to get xml export through dscmdexport as per my understanding.

The command dsexport.exe(DS7.5) export the data stage job in xml format but it will not include the dependent components like build ops or table definations. But DS8 dsexport xml works fine it includes all dependent components autometically without passing any specific parameter with the command. Do...

use /xml just before the target location

Thank you your hints helped me.

It looks like when we rename a table definition the value of Data Source Name and Data Source Type do not change.

It reflected the old one. I changed them and it works. Resolved!!!

When i click on "Select Table" under the table name column it pops with a window to select the table definition I require. I selec the table definition and then click OK. But the table name column yet shows the old one. I even tried clicking on OK rather than generate and open the buildop ...

Table Name is the column name on the Input and Output tables of the Interface tab on the buildop.

This column holds the path to the table definition of the input and output links.

Hi All, We have recently moved to DataStage v8.0 version and have been exploring the new tool. We have built some buildops as done on v7.5 but are facing some issues on v8.0 as to the way it works. The buildop runs fine and gives the required results. But on the interface tab of the builop for input...

I set the Epoch value to 2000-01-01 with Initial Value: 2009-08-04 and Limit: 2009-08-05. This i receive the following dates 2005-07-02 2005-07-02 2005-07-02 2005-07-02 2005-07-02 2005-07-02 2005-07-02 Any other option missing? I even tried giving Epoch to 2009-08-04 it does not work. Thank you WFIS

Hi, We are trying to use Column generator stage to generate two dates in a column as following Column1 ________ 2009-08-04 2009-08-05 2009-08-04 2009-08-05 2009-08-04 2009-08-05 2009-08-04 2009-08-05 I have used the following setting in teh Edit row option Type: Cycle Inital Value: 2009-08-04 Limit:...

Hi, We have a requirement to call a DB2 sql stored procedure in our datastage job. This procedure has no input of ourput stages present. Tried searching the forum but did not receive any clear picture. We do not have a stored procedure stage on our DS PX 7.5.2 version. We only have DB2/UDB API, DB2/...

Any help on this.

Does ProfileStage save reports on the analysis server or data server by any chance.