DSXchange

your PI columns should be the same one used in the where clause.

there is no such thing as first record in the table.. you need to specify on what condition you need to pull the record

there is no such thing as first record in the table.. you need to specify on what condition you need to pull the record

it gives 3807 error when the target table does not exist.... the one you are trying to insert into...

The TPT stage in immediate mode is recommended for small chunks of data as it commits on every few hundered rows which makes it a bit slower than the bulk mode stage. The enterprise stage on the other hand uses bulk fast load with multiple instances which gives a high rate for loading data and hence...

what does the mload report file say ? why has it failed?

If i were you i would do it in by writing a SQL for the join in teradata.

Thanks , Yes and having trawled through the documentation i came to know that the MS OLEDB stage allows us to create (Server Jobs) multi dimensional cubes but locally only not on the OLAP Server . We can write to and read from these cubes.

Hi,

Just wondering that if i have to connect to cubes for example Oracle, Microsoft or Hyperion Essbase cubes how can i do it through datastage ? or is not possible is there a workaround?

Thanks.

not sure visual c++ will do any good. try installing some other compiler. are you getting any values against the compiler in the admin ?

is TPT installed on the server?

Specify a different Terasync id for each job.

the database name used is called UNIVERSE and you can access it using the universe stage or by issuing commands from the administrator. And no there is no Xmeta in 7. Only V8 onwards.

The respository for version 7 would be file based in the project folder under the path 'Ascential\DataStage\Projects\PROJECT_NAME, with folders names like RT_XXXX etc

yes and a C++ complier too