DSXchange

Hi Kenneth,

Could you please elaborate it, please?

Thanks,
Sanket...

Hi All,

I wanna make connection to MS Access through DataStage PX(7.5.1A), OS: Unix .

Did anyone successfully make it?
I have explored the previous topics but got confused.

Can we connect without Datadirect or is it necessary?

Please give the steps do the same.

Thanks a lot,
Sanket...

I am currently working on DS PX in my current project. But my next project requires the Data File to be loaded into Database using SOA feature. I am not aware of the features,functionalities,limitations and implementaion strategy for SOA. Can anyone please provide me with the details and some user m...

Hi Guys,
I am Currently working on DS 7.x PX edition, needs more info on SOA part as our clients need to implement it and we need to know more about it in details.

Please provide me with more details about it and if there is any User Guide or Tutorial , it wud be great.

Hi,

When I open my Designer/Director/Manager I am getting following warning in windows error message box,

WARNING: Repository interface Tracing is switched ON.

Any idea?

Thanks,
Sanket...

Hi, You need to put alias for start date and end date as follows, SELECT SALES_CYCLE.CYCLE_CODE, TO_CHAR(SALES_CYCLE.BEGIN_DATE,'YYYY-MM-DD HH24:MI:SS') BEGIN_DATE, TO_CHAR(SALES_CYCLE.END_DATE,'YYYY-MM-DD HH24:MI:SS') END_DATE FROM ETL.SALES_CYCLE SALES_CYCLE WHERE SALES_CYCLE.BEGIN_DATE <= sysdate...

Hi,

You can just put following code in ur constraint to serve ur purpose
num(Field)

num(Field) : Returns True if Field is numeric.

Will you please mention the answer. As I am aslo getting the same warning.

If writing to file is not mandatory then you can put copy stage as trash.

Hi DS Gurus,

Instead of writing user defined query under SQL tab in Oracle stage
I wanna specify sql file to read data from Oracle database.

How can I do this?

Thanks,
Sanket...

Hi Laxmi, If your data is clean and ready to satisfy the constraints of target table then there is no issue :lol: , using 'Load' method to load data in faster way. Now if you want to insert data by user defined insert query then use upsert method(user defined insert and update). Put your insert quer...

Thanks for your replies.

Not exactly getting how to do this.
My DS is installed on the UNIX server and has only default user 'dsadm'.

So, do I need to create one user using UNIX and then link it with DS?
Or by any option in DS client can do it for me?

Thanks,
Sanket...

Hi DS Gurus,

I am using DS 7.5 installed on Sun Solaris.
I want to create one more user for DS jobs development.
How can I do the same?

Thanks,
Sanket...

Hi DS Gurus, I have written a simple PX routine. For this I wrote simple C code which just returns simple int value. Then compiled the code with gcc & created the object file. Now when I am calling that routine from a PX transformer, getting following compilation error :cry: Transformer_221: Fai...

Thanks a lot for your replies.

The code is working fine now, but as I mentioned it is returning the numeric values like 8, -7.
I am not able to get the meaning of these codes.
So any upgradation on this front?

Thanks in advance,
Sanket...