DSXchange

I'm investigating whether or not Datastage can provide webservices functionalities. I know, and already used, that a job can be invoked via WS. However: - I'd like to have the possibility to invoke a webservice stored on Datastage, may be passing some job parameters, and wait for the response. This ...

But what about performances with so many rows? The current solution is that if the count() in the two tables are different of at least one row, then target table is truncated and then everything is loaded from scratch.

Hi all, I've never used the Change Capture stage in a PX, but I know that it can be used to extract the differences between two tables, in particular the T1-T2 (probably it would need to run twice, T1-T2 and T2-T1, to get all the differences). What about performances? I had to check whether or not I...

Hi All, I've two PX jobs to be runned in a Sequence job: 1) the first query an Oracle DB_1 table and get the max_date from a table 2) the second accept a parameter that's a date and performs queries on Oracle DB_2 There are no possibilities of DBLinks. How can I pass the result of the first job to t...

No need for an additional stage if it's already available in the User Status area of one of the jobs in the Sequence job. Besides, that wasn't the question. Juls asked about accessing it from two sub-sequence jobs called from a third top level sequence job. The User Variables stage won't help here....

Of course they can be "undone" but I've never run into a situation where I've had to do anything of the sort in say, parent tables because of problems in the child tables. At least not in Production. :wink: As noted, constraints are fully qualified / checked / handled in the job designs s...

keshav0307 wrote:

If i dont specify the format what happens..???

then what will be your command??


it will fail to convert.

Hi,
does anybody know where I can find a DS manual with the list of available transformation functions, please?

Thanks!

My solution is perfectly valid, I have thousands of production jobs that do this very thing. The jobs are properly designed so they do not violate constraints of any kind. I ha ... My concern wasn't about your jobs, but about the outcome of your post. It could be possible that an insert statement f...

Ugh. I use separate jobs for each table and run them in the proper order. Transaction Size is always 0 so there's no "inconsistent data", it is all or nothing and the jobs ensure no "exceptions" occur ... By doing what you're saying, seems to me you have the risk to load (and co...

I'm designing a datamart that takes data from various sources and load into a couple of tables which structure is connected with some constrainst. That means that: 1) I need to load tables in a certain order (master first, detail after) 2) I need to load tables in a unique transaction to avoid inco...

I'm designing a datamart that takes data from various sources and load into a couple of tables which structure is connected with some constrainst. That means that: 1) I need to load tables in a certain order (master first, detail after) 2) I need to load tables in a unique transaction to avoid inco...