DSXchange

Can Datastage handle the real time like Sunopsis? It is said that using Sunopsis, It first journize the source table, which means tracking the source data change. Then the job is set to only use the data that has changed. The job itself is developed as usual. In this approach, it makes real time ETL...

But how SOA works? Subscribe and inform? Or event-driven? Does this mean to modify the operational applications to generate events?

Hi there, Under ReaL Time in the Datastage Designer, there are three stages: XMP_INPUT, XML_TRANSFORMER and XML_OUTPUT. How are these stages used to handle real time data transform? Does the source operation system generate XML file with its operations as the source XML File? Or messaging service do...

In order to use user-defined SQL statement to join two db2 databases, you need the DB2 federation configuration.

That's a good question, I'd like to hear the answer too.

Is there a place to download a trial version of ProfileStage?

Thanks,

rhys.jones@target.com, thanks for your response.

Is ProfileStage rebranded from MetaStage?

Hi there,

Who will use ProfileStage: Data Modeller or ETL developer? At which stage or stages of your project, do you use ProfileStage: project analyzing stage, data model, or ETL coding?

Thanks,

Hi there, How does QualityStage work together with Datastage: as a plug in or write the result to some place, then Datastage read from it? Who will use the QualityStage: ETL developer or quality assurance staff? It is said: "WebSphere QualityStage analyzes data at the character level and uncove...

I think the Pivot stage do the reverse: read one row and write multiple rows. Can Pivot stage do read multiple rows and combine them into one?

Thanks,

ArndW, thanks for your quick response. I don't understand "Job parameters are no longer modifiable.". Can we still call DSSetParam(hJob1, parName, parValue) to set a value to a job parameter? Yes, in this post, I mean if a Before-Job subroutine can set a job parameter of the job invoking t...

:oops: Can a DB2 table join with a Datastage hashed file to do a query? Such as, the SQL statement is as the following: SELECT x, x, x FROM EDW.TableName1 where UPD_DATE>= LAST_UPDATE_DATE AND UPD_DATE< #PROCESS_START_TIME# Here PROCESS_START_TIME is a job parameter. This SQL is executed on DB2 serv...

In order to split ETL to E.T.L, a integrated job can always be built first as ETL. When the job is tested, it can be split to 3, 4, even 20s E.T.L jobs, to make it confirmed to the practice and the maintenance and support more challenge, that's the best practice?

:lol: Hi guys, There is a practice in ETL coding: Separating Extract, Transformation and Load to three or more jobs, in order to in case of failure of some step, the previous steps can be reused. That sounds good in theory. Could any one tell where is the practice documented? Have a nice summer day,

[quote="chulett"]If you've created them using the 'pathed' option, then yes, backing up (in some form) the entire contents of their folder is sufficient.[/quote]

But How can it be backed up if the Account Name is used with empty field?

Thanks,