DSXchange

Hi, I want to design a job in such a way that,have to create the hash file in the first transformer and in the next transformer i have to use it as lookup. when i designed like this ,job is failing saying that not able to open the hash file. so is there any settings need to follow ,so that hash file...

Hi,

1)First sort the data based on Deptno and Sal in ascending order by using sort stage
2)After that use the remove duplicate stage and set Duplicates to retain to First

When you execute any unix command there will be Field marker at the end of the output,so try converting it to empty in user variable avtivity.

Convert(@FM,'',Command.output) and use this output to your job.

Try using below logic

StgVardate=TransDate[1,4]:'-':TransDate[5,2]:'-':TransDate[7,2]

In another stage varible give the derivation like this

If StgVardate[1,2]='20' And IsValid('date',StgVardate) Then 'Valid' Else 'Invalid'

Hi all,

when we have a remove duplicate option in sort stage, why we
have a remove duplicate stage in PX, thought it is
recommended to sort data before using a remove duplicate
stage.

If any one knows please answer

Hi chulet, Thanks for your reply. I am facing problem while creting the footer record. I have to specify constraints on the header and footer links or else i will get header and footer records as of number of detail records. for header record i gave the constraint like @inrownum=1 so we will get onl...

Hi all, I am creating a fixed width output file in a datastage job. I want to add the header and footer records to the output file File format: Header record --->will contain the record type,and source group name Data record----->actual fixed width data Footer record--->will contain record type and ...

Hi all, I am facing problem with odbc stage. In my job i am doing sparse lookup with ODBC stage and Lookup query is simple select query,but i am getting fatal error as " [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]NUMBER OF HOST VARIABLES SPECIFIED ...

Hi all,

Thanks for your responses,

My problem got sloved,actually the datatype is decimal(4,0),
datastage is treating it as integer because the scale is zero,
So if i change it to integer its working fine.

Thanks for your help

Hi ,

Thanks for your responses.
The datatype of the fields in both link are same and it is decimal(4,0).

I tried converting both fields to varchar and then doing lookup that time its working fine,

I am not getting what's wrong with decimal datatype.

Hi all, I am facing problem with sparse lookup. If i do sparse lookup with a key field having datatype Decimal (other than varchar ) ,even though matching records are there in the reference table,lookup is not working. But if i do the same thing with key field having datatype varchar its working If ...

Hi Chuleet,

I am not using result as a key column,and i am using rowid as a trigger column.

In the transformation setting i enabled Replace NULLS with empty values,single tag for empty element style apart from this i ddin't enabled any thing.

Thanks for your help

Hi All, I am facing the problem with the XML output stage. My i/p: rowid|result 1|abc 1|xdf 3|asd I am using rowid as a trigger column. So for rowid 1 the corresopnding result values abc,xdf should come under a single rowid chunk means i want the output xml like this <DMSMessage> <sourceSystemEventI...

Hi all, I am doing sparse lookup in my job with 6 key fields with db2 database. I gave the lookup query like this SELECT INTRACT_KEY_MAP_ID,CSS_FLD_ORGAN_ID,CSS_CLL_DT,CSS_CLL_TM,CSS_CLL_MICRO_SEC,CSS_PROV_ID_CLLR,CSS_PROV_ID_SEQ_CLLR,CCA_CNTCT_ID,CCA_INTRACT_NUM,CCA_REQSTR_INTRACT_CNTCT_ID,ERR_CNT,...

Hi, In my job i am just loading form sequnetial file to db2 table using Db2 bulk load stage. When i ran the job i got the warning as "TBL_INTRACT_KEY_MAPNG,0: Warning: TBL_INTRACT_KEY_MAPNG: Error allocating environment handle" and the job didnt completed its in running status only. can an...