DSXchange

Background: we are trying to process XML data (present in text column in sql server) using Datastage 11.3 (windows), Hierarchical stage. Objective is to convert XMLs into columnar data. There is another columnn in source table that tells us what is source of this data (XML type). As of now we have ...

We have been given a valid XSD which is version 1.1. When I try to import in Datastage Schema Library Manager 9.1, it results in error saying The {max occurs} of an element in an 'all' model group must be 0 or 1. The value '-1' for element 'customer' is invalid. We know this is limitation, where we ...

All my search resulted in DS 7.5 related repository query. I understand that DS 8.0 repository is installed on SQL Server in our case. Is there any way to query these tables or can you point me to some responses in dsxchange

I have to scan number of DWH datastage jobs where perticular table is used. There are complex user defined sqls as source extraction with lots of joins where this table may have been used. Is there a way to query datastage metadata to narrow the jobs list.

Thanks Chulett. Is there anything available to search whole project at one go. I have been told that most of the filters are in DB2/UDB stage as a sql query as where clause. Is it possible to get this from a metadata query which will list all DB2/UDB stage queries with associated job names? if yes c...

Below link might help you with some of answers.

http://blogs.ittoolbox.com/bi/websphere ... tage-22837

Not an excellent way of doing it but would like to suggest an option below. else i thibnk you have to go for custom stage. 1> Create a file in O/S (UNIX) to be used as lookup with layout as below. count, records 1,1 2,1 2,2 3,1 3,2 3,3 and so on 2> Use this file as multiple lookup to generate your o...

I have a requirement to read DB2 (sitting on Mainframe) table from Datastage Server 7.5.1A ( sitting on UNIX AIX). I can see from existing post that its feasable. As existing post is from 2004 -05 and so just wanted to check if any new feature is available in datastage.

Guys,
When I "Generate Report" for any job. The reports does not show column names. Its showing a table where column names are blank for stages but it shows associated datastye for same. Other properties are seen fine. Is there any setting we need to do for same.

regards,
santosh

PROBLEM: Guys I have specific problem related to xml stages. I have two tables i.e. ADDRESS,USER with data as mentioned below [A,B]. The output required is XML in format given [C]. ANALYSIS TILL NOW: I have managed to get output as mentioned in [D]. I developed a job inner joining ADDRESS & USER...

We want to run a job whenever we get a .done file in UNIX folder. I was able to look file using "Wait for file Activity" in sequence. But I want this job to get triggered automatically multiple times in a day. I mean i will get 6 or 7 .done files in a day. My job should run accordingly. Pl...

vmcburney wrote:If you were doing a lot of these you could go for the RTI pack and call it as a web service.

Hi Vincent,
Can you please elaborate more on how to use RTI pack. does this comes inbuilt with datastage

regards,
santosh

Guys we have to create XML output files. we have been provided with XML DTD to be used in output metadata as .rnc file. I trid to import but it does not acepts this file. Is there any work around or we have to no choice and ask for .dtd file?

Hi all, We have a requirement to trigger datastage job via web page. When submit button is clicked, underlying job should run and web page should display error/ success result. I am proposing to write to write some ASP/java web page. on button click it will call DS job thru UNIX interface and displa...

Guys We have a data migration requirement where business wants to run the migration activity record by record for sometime(10 months daily). Then they will think if we can bulk transfer data. So what we are looking is a solution where business gets screen to put customer number and whole ETL process...