DSXchange

there are around 6kakhs record in the reference ........and i can not use join stage becoz i want the rejection.. and i dont believe on merge stage....i have seen that merge stage giving worng result...so plz provide me solution for this..??

Hi, I have developed the job in which i m using Lookup stage,but the job is getting aborted and giving error message is:- Lookup_1,0: Could not map table file "/etlstg/datasets/lookuptable.20090506.hlpp0hd (size 541052504 bytes)": Not enough space Error finalizing / saving table /tmp/dynLU...

Hi,
I have two columns in the source
cust name ,cust id
xxxx,01
yyyy,02
zzzz,03
abcd,04
and i want the job to be aborted when the cust name is "abcd".
So please help me to achieve this in datastage EE

Thanks in advance.

Hi,
I want to write a datastage API program to get link information using the function DSGetLinkInfo.Can any one tell me that where i have to write this program and how can i call in my job.....?


Thanks in advance

Hi all, I have a sequence, in which i m calling 5 jobs. In first job data is extracted from oracle db (oracle stage) and loaded into db2table(db2 api stage).If zero rows are transferred,then i want this job to be abort,so that my sequencer is aborted........please adivce me how to implement this..??...

Hi, I am using aggrigator stage in my job.job design is like this:- dataset---->aggrigator stage----->db2 stage I want sum of one column basced on five key columns.Column which i m using for sum is decimal(10,5) and i want o/p also as decimal(10,5).Some of aggrigated output are NULL but source has n...

vasa_dxx wrote:You need to explicitly Install ODBC pack for different DBs. For Eg: MS Excel, Oracle, Teradata etc.

Thanks for Quick reply,is it not available with datastage packages..???

Do you mean TO your DataStage server from something external, or from your DataStage server to some data source? The first would require an ODBC driver for DataStage Engine, and no such animal exis ... Data stage server means it is server to some data source and from where i can get ODBC driver,is ...

Hi,
Can any one tell me the steps of ODBC connectivity to datasgate server(my datastage PX server version is 7.5.1)?

thanks in advance

Hi, In Our project we have requirment to take a files from server which is windows(URL) and it will land on our aix server.I have connected two aix server by enabling the public key,but this is new for me.. :( ....If u have any idea how to do this......please reply to this topic. Thanks in advance

The "IDENT1" means it is a dummy stage inserted between two passive stages in the job. Are you certain that this is a Parallel job and not a Server job? What passive stages do you have in the job that ... I have job design like this:- source Db2-------->Db2 Target and this is a server job...

ArndW wrote:The "IDENT1" means it is a dummy stage inserted between two passive stages in the job. Are you certain that this is a Parallel job and not a Server job? What passive stages do you have in the job that ...

I have job design like this:-

source Db2-------->Db2 Target

Hi I am getting follwing error while compiling the job:- Error compiling genarated subroutine for the stage Compiling: Source = 'RT_BP335/JOB.1228002509.DT.1485535753.IDENT1', Object = 'RT_BP335.O/JOB.1228002509.DT.1485535753.IDENT1' ******************************************************************...

Firstly why? Default to decimal o/p=8,2 Here you are trying to squeeze your input (10,4) to (8,2) which needs to be looked into. Also how does your input data looks, does it have any Null values? I have chaged the input to (8,2) but still the same problem,and yes input data have the NULL values......

Hi All I am making simple job like this:- Ddataset--->aggrigator stage ------>Dataset Input columns are :- Columns Data types HUB Varchar CIRCLE Varchar DATE Date AMOUNT Decimal (10,4) I want sum of amount column basced on HUB,CIRCLE and DATE I have selected these in aggrgator stage:- Grouping keys:...