DSXchange

Attend the IBM Advanced DataStage class. You will learn about, and do, construction of a working Build stage.

Why "without using Aggregator stage"?

The correct philosophy is "the right tool for the right job" and, to aggregate data, the right tool is the Aggregator stage.

<rant>
Resist stupid requirements!
</rant>

Funnel stage.

Lots of ways.

How many have you thought of?

When's the interview?

Create load-ready text file using DataStage then invoke the bulk loader (bcp) under control of DataStage.

Import > Table Definition > Sequential File

Not to be trifled with, then.

Show us your design using "ASCII art".

IS there a file in your project called D_DS_JOBS ? (This is the dictionary for DS_JOBS.) If it is present, check the permissions on it. If it is missing, find out who stole it and kill them, then copy D_DS_JOBS from another project or from the Template directory.

There is a DataStage applet in control panel.

The individual services can be stopped/started from the Services window under Control Panel.

What are your own thoughts? Have you created a design of your own yet? Or are you waiting for an answer to be handed to you on a silver platter?

From where are you trying to execute the command?

Hang on. They've got ERwin. With one click in ERwin they can generate DDL. But they're insistent on doing in in MWB? (What's wrong with this picture?) Do they use a saw for tightening screws? (The concept you need to inculcate is "the right tool for the right job".)

How long is a piece of string? Heavier duty Windows servers running Windows Server operating systems are capable of quite large volumes of data, while a small laptop running XP would struggle with more than small to medium volumes.

Data string '2011-02' does not match format '%yyyy-%mm-%dd

Try using '%yyyy-%mm' instead.