DSXchange

We are just installing Information Server 8.0.1. Our users will obviously connect to DS server from DS client. Assuming that our IP is 210.100.100.100 for the server machine. Now, while connecting through VPN on Client what are the port ranges that we would need to specify.
Thanks!

We have a disparate environment. Source - DB2 on AS400. Staging area-DataStage Px and a target Microsoft SQL Server. What are different ways to connect to SQL Server from Solaris?

Does Windows have all patches installed as reqd. for IS installation?

Im installing IBM Information Server v8.0 on a 6 yr old Solaris SPARC machine. Details - SPARC has four processors 450Mhz each and 32 bit. Current Memory - 1. Physical - ~4GB 2. SWAP - ~4GB Disk Space available - ~10GB The System requirements for engine are - 1. 4-8GB memory for engine 2. ~2GB memor...

I'd appreciate if someone can briefly tell me about phantom and zombie process in Datastage. Thanks!

How could I call an OSH script from DataStage? Thx

I have an EBCDIC/Binary data. I have defined column layout. For the column type bit(8) the length is 1. When I try to view the data it seems to be having a problem with that column.
Additional info -
1. ASCII file on UNIX machine
2. Fixed lengths columns.
3. No delimiters.
Pl. help.
Thank you.

How to convert EBCDIC/Binary files to Ascii in PX?
Is there a function?

What could be done to avoid this transformation?
thanks

Char to numeric conversion. Any suggestions?

Wouldnt it be better to use the parallelism mechanism on the SORT in DS instead of a flat file sort outside of DS.
My understanding is a sort of DS is not utilizing the PX mechanism. Im assuming partitioning and sorting in the SORT stage would be faster.
Thanks! Pl. reply!

Hi,
I currently have a design where I need to Sort and Aggr.
Do you recomment a Sort in AGGR stage (or) a SORT stage followed by a AGGR stage. If so, why?
Thanks!

The way AGGR stage works on sum of decimal type columns is. When it performs a SUM it makes sure that no row is "null". When we contacted an Ascential pro' with the same problem. He mentioned it was a compiler related error, where the code needs to changed to avoid this problem in future. ...

ArndW,
Thats a well written response.
Theres no shortcut to success. Hard work is the only key!

I couldn't get the answer to this topic. I think the round robin would execute at the fastest rate. Am i right? Can someone pl. explain.
Thanks