DSXchange

Hi Gurus, My design is ODBC---->ROWMERGER----->ODBC. My source table has columns deptno, loc,dname. In Row merger stage properties. General i have selected multiple lines. In o/p Columns tab, i have created a new column called merged column. Name type length merged column unknown unknown when i comp...

Hi Gurus,

Thanks very much.
I have enabled create table in the target stage, there i forgot to change my datatype to decimal.

when i changed datatype for custid to decimal, its working fine.

cheers;
vijay

Hi, I created a table in oracle database using following query create table salma(customerid number, ename varchar2(20),jansales decimal(12,2),febsales decimal(10,2)) My design is odbc---->pivot---->odbc. Iam calling this table in my source odbc stage. when i run the job ,iam getting peculiar error....

Hi Gurus, One of my friend was saying that the actual way of the parameter is stored in DSPARAM file strictly. when i declared at administrator, i could find actual way of parameters in DSPARAM FILE. what abt when declared using .ini file and ds.param function. My first question is can we declare an...

Hi Gurus, I have searched the forum, and i found that there are several ways of declaring parameters. one is through administratior- projectlevel parameters. the other one is through sequencer assigning parameters and then allocate it to job activity. The other way is .ini file and using dsset param...

Hi Gurus, Is there any way of identifying the project level parameters and job level parameters.I mean to can by seeing the parameter declaration can we identify whether its joblevel or project level. #$param# = project level parameter #param# = joblevel parameter. am i going in the right way. cheer...

Hi Gurus,

As a Developer when can i think to go for performance tuning.

what are the aspects or when can i think that i need to do some performance tuning. Is by means of time ,its taking for the job.How can i estimate the time.

cheers;
vijay

Hi Gurus, How can I deal with job parameters in production environment,since these parameters doesn't have default value.I means project level parameters can be assigned default values like $projdef, but joblevel parameters cannot be assigned, in that case how to deal with these parameters. cheers; ...

Hi Gurus,
It is a custom stage.It falls under this category.
Can't i use this stage in server, bz when i used the operating system command " dir ", its working fine, i can see from the director.

please Gurus help me .

cheers;
vijay

Hi Gurus,
Iam working on server and my operating system is windows.

cheers;
vijay

Hi Gurus,
My datastage version 7.5.
Actually command_stage is a plugin stage.
Please Gurus help me.

cheers;
vijay

Hi Gurus, My design is ODBC----->TRANSFORMER----->SEQUENTIAL FILE----->COMMAND STAGE. its running fine till sequential file, iam getting problem in using command stage. In the properties of command stage, iam specifying command type as OS I gave command "print", i also tried giving "d...

Hi,
I dont have access to FTP.
My file is in local directory itself.
Inorder to do FTP , what should i do, can i use FTP to retrieve from my local directory.please help me.

cheers;
vijay

Hi Gurus, My design is FTP------>SEQUENTIAL FILE. Iam selecting the file whose path is c:\HashFiles\vijay\salma i want to dump the data in that file into sequential file. In the FTP properties. server name- system name----->i entered the system name. user name- i entered Admin since this is my user ...

Hi Gurus,

Thanks very much, i could solve the problem, iam marking this topic as resolved.

cheers;
vijay