DSXchange

1. No u cannot change how TD handles data distribution. if u have 96 AMPS it will distribute data on them using its own hashing algos. If u think all data is on one amp it means there is a serious skew factor in ur data i.e. non uniqueness and kills the basic theory of parallelism when it comes to d...

Hi all , well i know this was discussed before but that guy who posted it for the first time just said at one point its working now and dint bother giving the solution.. i am having the same problem when i work with dataset.. i am just testing the compress stage Dataset---->> Compress stage---->>> d...

Hi all, Is it possible to write a config file which has two nodes and each node pertains to two different servers.. that is if i have two servers S1 and S2 .. can i write a config file ABC with nodes N1 and N2 .. where N1 has procesing power of and uses disk storage of S1 and N2 and processing power...

I am attempting to both read and load to the same view of a table within a DataStage job, using Multiload and getting an error which DataStage gives as "APT_TeraSync: could not create operator sync table".


any ideas ?

just a general question about DS connectivity.. when i try to run DS on local machine without LAN connectivity it fails to connect.... .any ideas '? do i need to install any loop back patches ?


thanks

try releasing the multiload............

Multiload allows you to load upto 5 populated tables at the same time.... as its a Teradata API it self so it is based on a pararell architecture.

use fastload for empty tables only

Hi , just depends on the situation

if u r trying to populate an empty table then u can use fast load(always for empty tables)...

the only thing u can use for populating non empty table is the multiload and teradata api ...

and yes u can use teradata api in server jobs

i just tried importing a job which i exported from another machine running datastage on the same OS, i am getting the following two issues. 1. job can only be imported when the client code page is 1256 . currently it is 1252. 2. incompatible release or the file is expteced to be in windows format an...

Does any one has this documentation please ? i would appreciate if you can send it to me as i really need it

if it can be mailed at: spicy_clumsy@hotmail.com

Many thanks , much appreciated

Ascential recommends you do not install Windows XO SP2 on a machine running the DataStage Client software at this time. Windows XP SP2 was released publicly by Microsoft on August 16th, 2004. Microsoft has since published several lists of over 100 applications from 3rd party software vendors that ha...

yes i am running of xp .. not sure what these patches r ? and how can i get them ?

thanks

Yes nick its a new install and i did create a project during the installation.. i tried creating a freash project and gives me the same problem

cheers

Try the string function .. something like this .. i have done it and worked for me Str(string, number of times to be repeated) i.e. STR('0', 3): FieldName woud pad three zeros to the left of FieldName so if you write somethin like STR('0', Length of Actual field - Len(Link.ActualField) : Actualfield...

Hi, i have some problems when i try to view the properties of a particular project. i log in as a admin . am able to create a project . but its just does nothing and goes to non responding when it come to the properties view ? just wondering are there any particular check list i need to go through t...