DSXchange

Hi, How can i do below: Example 1 Source: 10005822 10/16/2003 11/20/2008 A008 105404--- line 1 10005822 10/16/2003 3/31/2009 A999 105404 --- line 2 10005822 6/23/2008 7/5/2009 A008 124530 --- line 3 10005822 11/21/2008 8/31/2009 A008 105404 --- line 4 10005822 8/31/2009 4/16/2010 A008 105323 --- lin...

Hi, My dates are coming as varchar format as 20100503 i want to "%yyyy%mm%dd" and do -1 day too somehow -1 day is not working in syntax below please advise. Thanks IF IsValid("date", DSLink19.HRP1001_BEGDA -1, "%yyyy%mm%dd") THEN StringToDate(DSLink19.HRP1001_BEGDA -1 ,...

I converted it to .csv still same issue

Hi, I have data which looks like below in xls file, i am using sequential file to view data Properties are: Record level none Feild defaults delimiter none Quote none I can see company_tcd data as meesed up and doc_num as all null COMPANY_TCD DOC_NUM 1000 3000012010 1000 3000012010 1000 3000012010 1...

Hi, How can i do below logic Source data: PERNER BEGDA ENDDA PERSG PERSK 00000351 19410130 19880303 1 12 00000351 19880304 19990627 6 65 00000351 19990628 99991231 5 50 00103016 19970421 20031015 A AA 00103016 20031016 20050619 A AA 00103016 20050620 20060521 A AA 00103016 20060522 20061116 A AA 001...

Hi,
Which Actvity Variable capture Unix Reply code as i don't see any Reply code variable in there all i see in Activity variables are:

JobName
JobStatus
UserStatus

Want to capture Reply
Reply=0
Output from command ====>

Can you please remove premium content from post as my membership has expired and i have not renewed it yet

Hi, Source date look like doc_num , doc_num_reject ,cost_sk ,order_sk ,doc_last_num 123 123 -1 -1 null 123 -1 202 123 how can i compare two rows and populate doc_num_reject( -->123) for second row. doc_num , doc_num_reject, cost_sk ,order_sk ,doc_last_num 123 123 -1 -1 null 123 -->123 -1 202 123

Then they breaking change control process.if there is issue in prod code
it should be fixed in dev and then promoted to uat/prod.

Production issues should not be fixed in prod they should be fixed in dev
and then promotion should be down.

DS Admin

In stageVariables i am doing below for StageDocNum If (to_transf.COST_CNTR_SK<0 OR to_transf.ORDER_SK< 0 then to_transf.DOC_NUM else 0) and then on constraint i am doing (to_transf.COST_CNTR_SK< 0 OR to_transf.ORDER_SK< 0 and to_transf.DOC_NUM= StageDocNum) and it is getting the result any idea what...

Hi, I have below constraint in transformer to_transf.COST_CNTR_SK< 0 which reject the rows i need to modify it Right now it does as below Doc_num line_num COST_CNTR_SK 123 1 -1 ---reject 123 2 56 -------load in table Now we want to reject both rows if doc_num is same. how can i modify the constraint...

Hi,
I have a requirement to pull data from mainframe any idea what steps we need to do or any document or link i can see which can give me idea who it can be done.

Thanks

Hi, I have below program which call the shell script if i execute it it gives me below warning but if i execute via execute command it works so any idea what can be wrong in below program. csh /ds01/app/scripts/custom/FIN/wrappers/cubes_quarter.wpr: not found Program is: *Initialize variables vShell...

I am doing custom trigger now still not getting warning and yes automatic error handling is enabled in the sequence if Build_Cube_Quarter.$ReturnValue <>0 then JOBSTATUS =2 else JOBSTATUS =1 Reply=127 Output from command ====> /db01/c10_cubes/script/DSFINBUILD_Quarter.sh: line 2: -: command not found