DSXchange

I want to replicate the universe repository into another Relational DB which can be anything... Oracle, SQL Server etc. Thus to be able to do that i need to read the universe repository tables. Is there any other way in which i can do that?

Hi,

I tried using that query..... it gives me the table definition list. Its does not give me the column names and details for the universe repository tables. How can i get to know the column names and column details for these tables?

Hi,

I want to read the datastage repository tables. To be able to do so i would need the table definitions of the universe database tables. How can i import the metadata of all the tables in the universe repository of datastage?

I also tried the same way but the problem was 'key' for the hash file. I found another way. I added a transformer before the aggregator. Then added dummy column in both the transformers,new Trans and Trans1 (in exactly the same way), carried it over to HashFile and made it as the key for the lookup....

Sorry,some formatting error. The vertical Lkup bar/output bar is at the end of the diagram...Lkup from HashFile to Trans2 and then final streaming output from Trans2 to Output File.

I was just wondering if there is any way where I can have a lookup irrespective of what the hashfile key field is looked up against. In other words can I look up a hash File for a particular field(say to be used in transformer) in all circumstances and have that for manipulation of all the incoming ...

Hi

How can I use JOB parameters in the Email notification activity stage.
I do not want to hardcode the Recepients Email address in the mail notification activity stage.

Thanks
Sreeja

We have a hashfile containing 5 columns. Job 1 and Job2 use this hash file for reference lookups. Building two hashfiles instead of one common hashfile is not an option available to us. Job 1 uses 4 columns of the Hashfile and job 2 uses 2 columns of the Hashfile. As of now for both jobs, while impo...

Actually I too am against the use of such a large hashfile for lookups. What we are trying to do is this: 1. Table 1 contains customer details. 2. Tables 2,3,4 need last name, first name and zipcode too on their fields. Table 1,2,3,4 are loaded sequentially one after the other. Each table recieves d...

Hi I am new to DataStage and hence have been innudating the forum with a lot of beginner questions. Here's one more. I have to create a hashfile containing 30 million recrods. Key column:customer id varchar20 Nonkey columns: customer name, zipcode. total size 60 bytes. i.e. size of each record size ...

Is it possible to pass stage variables used in a Transformer Stage as a parameter to the shell script I am calling in the After Stage job? If not, are there any alternatives?

An oracle OCI9i stage returns a one row that contains only one column. I need to assign it to a job parameter. I tried doing
"JOBPARAM"=last_seq_num.


But the After tab expects a SQL.

I need to use the value returned by the OCI9 stage in a stage variable and increment it by 1 every time.

I would like to know more about TCL. Where could I get information on the same.

Thanks
Sreeja

Many Thanks for the information. It helped me a lot.

Its is a 64 bit machine. But the DataStage software is 32 bit, so my DS administrator says.

How do I manually create Hashfiles?