DSXchange

Requestors of the Sync Contact service can initiate the service via MQ Series or HTTP(S) via the FxHub ESB based on the requestor's preference. In either case, the service will act asynchronously. The FxHub ESB will pass the request to the Routing Adapter Service and to the CRM Siebel environment an...

Hi,
i used after sql in db2 stage to call below export its giving errors any idea
if i can do this in datastage.

EXPORT TO C:\Datastageexports\emea\test.ixf
OF IXF MESSAGES "C:\Datastageexports\emea\test.msg" select * from SYSIBM.SYSDUMMY1

Hi,

FISCAL_YEAR_NUMBER is decimal 4
JE_PERIOD_NUMBER is decimal 2

i want to get SORT which is decimal 8 as 20141 20142

i am doing as below its just giving me 2014 no period number
FISCAL_YEAR_NUMBER : JE_PERIOD_NUMBER

Any idea what is wrong

Hi,
Is there any parameter which we can use to Override default 50 warning message in sequence.

Thanks

Will this work

svCurrent=InputCode
svRank--> if svCurrent=svPrevious then svRank else svRank+1
svPrevious=InputCode

Hi,
i have data as below

CODE
421
BD
AA
AA
CD
KK
MM

i Want to create sequence based on Alphabetical order

CODE seq

421 1
AA 2
AA 2
BD 3
CD 4
KK 5
MM 6


Thanks

Hi,
I am trying to convert varchar(05) to decimal(5) my doing as below but i am still getting 05


Thanks

Agree so what should it be

Parent_code child_code CHILD_SK PARENT_SK 00.1 1 ABC.20 ABC 2 null ABC.20 CDE.20 3 null ABC.20 EFG.20 4 null BDE.20 ABC.20 5 null i want to update parent_sk as below based upon join from parent_code with child_code: Parent_code child_code CHILD_SK PARENT_SK 00.1 1 null ABC.20 ABC 2 5 ABC.20 CDE.20 ...

Input_Lnk Parent_code child_code CHILD_SK PARENT_SK 00.1 1 ABC.20 ABC 2 ABC.20 CDE.20 3 ABC.20 EFG.20 4 BDE.20 ABC.20 5 I am using stage varaible to get parent_sk like below in stage varaible i said Input_Link.child_code StageVar In Transformer to populate PARENT_SK i said IF (Input_Lnk.Parent_code=...

Hi, Can i do below scenario using SCD emp_no and emp_date is business key Day 1: in dimension sk emp_no emp_date eff_dt end_dt 7 123 9999-12-31 2013-12-01 9999-12-31 Day 2: in dimension sk emp_no emp_date eff_dt end_dt 7 123 9999-12-31 2013-12-01 2013-12-31 --this row is delete in source and i want ...

Hi, My date is in varchar 8 format like 20010431 when i do conversion its coming as 4444-01-01 any idea what can be wrong Note: some dates are coming good but above conversion have issue EMP_START_DT_ORIGINAL:20010431 IF IsValid("date", to_transf.EMP_START_DT_ORIGINAL, "%yyyy%mm%dd&qu...

can you please take premium content out

Hi, I am trying to convert varchar(8) to date and also doing DateOffsetByDays below is syntax but transformer not liking DateOffsetByDays Thanks IF IsValid("date", DateOffsetByDays(to_trans4.S_AAA, "%yyyy%mm%dd",1)) THEN StringToDate(to_trans4.S_AAA,"%yyyy%mm%dd") ELSE ...

Hi, Let me rephrase the question i have record with range 2003-1-10 to 2012-12-31 from table A and i have two records from table B 1)2003-1-10 to 2005-1-31 2)2013-1-1 till 9999-12-31 i want to compare table A with B 1) if table B range within 2003-1-10 to 2005-1-31 A range the Arange =Brange 2) if t...