DSXchange

Learn it from ValueCap. They are ex-developers of PX. They can conduct on-site px course (with all bell and whistles).

My client organized training and I attended. It was great to know the framework architecture and OSH tricks. Ascential does not cover these topics.

Use Multi-load. Enterprise option used to be faster in V6 and in V7 it is slow ( it uses temp tables). Multi-load also a server plug-in. It needs to convert data from PX to Server to Sequential. So use Named pipe to move the data into Teradata. Does anyone have performance stats on enterprise vs mul...

Yes. You can copy dataset from one machine to another. I have done it. I copied from Ver6.0 to Ver 7.1 on Solaris machine. This process is not straight forward. I have to set NFS mount point between the machines and use modified config.apt file and copied between the machines. (Use Orchadmin or osh ...

Hi Any one has experience in converting/moving dataset from one machine to another (from version 6.x to 7.x). I am have some issuess in reading version 6.0 dataset in 7.5 We have installed version 6.0 & 7.5 in the machine for upgrade and moved data sets from current production to new machine (wh...

Here is the basic stuff: 1) Use reject link in transformer, lookup stages to capture missing data 2) Use APT_DUMP_SCORE to get details 3) Read the OSH script to understand 4) Read log files to see what errors/warnings reported 5) When you gain experience, you can write custom DSRoutine to capture al...

You can split dataset in two ways 1) create a small job which reads the dataset and writes to another dataset. When you run, give the correct $APT_CONFIG_FILE which tells how to split the file (you have to create correct config file) 2) If you are familiar with unix, then use orchadmin command. Siva...

You can use DSJob routine that can check the total records from the file using "dsrecords" command from the unix prompt. You should write general routine which calls unix commands.

sconner wrote:Hi,

Is there a way in DataStage wherein we can check if the dataset is null or not?

cheers,
sconner