DSXchange

Hello,

How can we find that what partition method was used during an execution if the "Auto" Partition is used in the stages?

Thanks

Hello, We have been running our Datastage jobs for a while now with Teradata as the target database. On a routine check... we saw that the work database on Teradata is growing in size. When looked we have a lot of tables starting with ORCH_WORK_ followed by some numbers. Does anyone know what these ...

I am currently using the MLOAD with a Before Script to delete everything from the table with a table.date > run-date. As I have communicated before, the destination table would still have few billion rows even after the above delete statement. Later I am using MLOAD Insert to insert the 750M rows in...

Hello, It may be a very basic question for most of you. When do you use Mload Vs Enterprise Stage when loading the data into Teradata. My situation is that I have 750M rows to be inserted into an existing table that has already 2Billion rows. I also need to pre-delete (based on the run-date before i...

Actually... we do not have the databases on the same server as the DataStage. We were using the EZCONNECT instead of tnsnames.ora. It was working before because the port that we were supposed to be using was the default port on the server. But, with the change in the port numbers... the default port...

Thanks. I found it.

Hello, Where could I find the documentation regarding the Shared Container. It is not found in the manuals that is installed on the PC. Do we need to choose a special option to install these? Also... I did not find the documentation anywhere on the sequences and the stages that you can use in them. ...

Thanks a bunch. It worked.

We were in a different discussion on that one. Got it working. Thanks

You are right on the money. Yes, I need to have the count of rows in a table available in a sequence.
I have written the count to a text file.
The challenge is how to read the text file and get the count available in the sequence for me to perform a conditional branching of jobs.

Please assist.

Hello,

I am using the execute command stage, to call a ksh script, which prep's a temp table with the rows.
How do I get the rowcount from that table back to the datastage sequence.
I wanted to do a conditional flow based on the count that I receive back from the ksh script

Thanks

Worked for me too...

Hello, In a sequence I have an execute command which calls a bteq to populate a table. Upon successful... the sequence continues to executes the next stage, which is a datastage job that joins the table that is populated in the previous stage with another huge fact table. Most of the time the first ...

Dummy column with the same value worked. Thanks.

Is this not the right forum for this question?

Hello, I have few columns coming from one oracle stage and few other columns coming from another teradata stage. How can I do the product join between these two and what stage should I be using for this? There are no common columns between these two sources. I mean from Oracle instance I have column...