DSXchange

I have a file which contains 40million records and i need to sort the file 5 times using different keys and then take the unique record for each group. So what is the best way to acheive this whether to use inmemory sort and take unique record or sort by using external sort stage and keed unique rec...

Is in link sort use datastage scratch space or memory.

Thanks

Is there any command to view data from lookup fileset stage.

Thanks

Now i installed VisualC++ 2005 express editiotion.Still I am getting the following error. Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 16:39:11(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4458 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights ...

I installed Visual Studio .NET 2008 Express Edition C++ .Still i am unable to compile parallel jobs with transformer.Can any one please tell what are the values i need to user for the following env variables.


APT_COMPILEOPT
APT_COMPILER
APT_LINKER
APT_LINKOPT

Thanks for your help

Hi,

I want to divide 364/30 and i am expecting valu 12.13,But when i did in a transformer by putting data type as decimal i am getting 12.00.What i need to do to get the exact value instead of zeros.

Thanks

HI,

Is there any way to get the stage names like (oracle,Tranformer,Aggregator,Join,Lookup) used in a particular job.

Thanks

I have 6 columns in my file.

ID,CODE1,CODE2,CODE3,CODE4,CODE5
123,300,200,500,600,20
123,400,40,30,300,20

I need the output like below

ID,CODE1,CODE2,CODE3,CODE4,CODE5
123,300,200,500,600,20,400,40,30,300,20

Can any one have any idead about how to do this in datatsage

Thanks

Hi,
we applied a patch on our dev system and in test i need to check whether the same patch is applied or not.Is there any way to find out ?

Thanks

I need to pass Column name as a parameter to do some claculation.

Ex : Linkname.Columnname.

Here Linkname is always same but Column name is different.I want to Pass this as a parameter.Is it possible in datastage if i use Runtime column propagation and with out RCP also.

Thanks

HI,

Is there any way we can query DS tables to check whether password is encrypted in jobs or not, because i need to check all the jobs before moving into PROD .

Thanks

By using dsjob command can we get list of jobs in a particular category?

Hi,

I want to export specifi category of jobs through command line.Can you one tell what is the command line for that.

Thanks

I created a routine and in the routine i have a code like below. Ans=1 when i call this routine using routine activity i am getting the following warning and is aborting. seqTest.Test.JobControl (@Routine_Activity_38): Routine DSU.Test did not finish OK, return code = '1' seqTest.Test.JobControl (@R...

Hi, I have a input data like below ID,ID1 5,100 5,200 5,300 6,400 6,500 6,600 1,600 1,700 I need the output like below. SEQID,ID,ID1 1,5,100 1,5,200 1,5,300 2,6,400 2,6,500 2,6,600 3,1,600 3,1,700 For similar IDs i need to assing same sequence number.Can any one please help me how to implement this ...