DSXchange

When i try to run web services i am getting error as main_program: Syntax error: Error in "export" operator: Error in operator arg: In field "PostalCode": Expected ";", got: ".", line 322 In field "PostalCode": Expected ";", got: ".&qu...

ray.wurlod wrote:Use Optim. ...

But here i have to use unix script it seems and how this process is like i have to extract data from extract feeds and load it into ODS and than i have to create archive database of those repositories in ODS using archival script

Is this approach right

HI i want to archive the data from ods for 2 years how can i achive this purpose?

chulett wrote:How about an answer for the second question.

i want to create generic jobs for each module and maintain history how can i achive this

chulett wrote:Are you asking if you can build generic jobs per module using something like the SCD stage, schema files and/or RCP rather than specific jobs per table? What does "I need only to append the data into ods" mean? To me that doesn't sound very type-2-like.

Yes chulett

hi i want to implement scd type 2 with timestamp in my project i have 3 modules like claims,capitation,duncan and i have to load it into Sybase ODS.

I NEEDonly to append the data into ods so can i use 3 scd jobs or i have to use scd jobs dependent on each table.

How to achive archival process in datastage as i have to archive data from ODS and load it into datawarehouse for 2 years and 5 years respectively.

what are the stages i can use here whether i have to maintain history if yes than i have to go with cdc right.

Please guide me on this

@DSGURU i am not a premium member so i can't read it can you explain it again

but here i have to do everything from gathering requirement to design and coding

so how this is done actually i have to write some scripts for archiving so that i can call jobs from sequencer using execute command activity

i want to know what actually data archiving is as i have to archive data such as claims,capitation,positive pay and duncan repository for 2 years and 5 years so wat are the steps how i should proceed further in order to prepare HLD and LLD