DSXchange

Ray,

...the hashed file normalized on the multi-valued column.

i dont understand this context. can you pls explain it?

All, In our company we are using DB2 as the repository. I came to know this from the DSADMIN team. is there any way to find the repository database ? i.e through any command. say for example, in sybase or sqlserver we can use @@version to know the version details. like that is there any command avai...

Thanks !

v2kmadhav wrote:Use it wisely ..

!!!

???

where i can find the list of token variables ? i mean in which manual? i have recently faced an issue. I used environment variable for the password. when i run the job , it failed with "Login Failed" error message. I just checked with DSADMIN team and they edited the environment variable a...

which ODBC type?

ODBC Enterprise ! ?

or

Parallel Job - ODBC Enterprise to connect SQL Server

can you tell me which stage property control this?

All, I have developed a simple job to load a csv file content to a table. The line termination of the file is "LF". i.e. Unix Line Termination. Under Format tab, I used the below properties in the below mentioned ORDER . Final Delimeter = end Record Delimeter = Unix NewLine when i run the ...

ODBC Stage - in Parallel

i just wanted to know the responsilibilty of those roles?

Hi All, Can anybody ADD/PURIFY thoughts on the role of Datastage Developer,Datastage Admin and Datastage Architecturer? Datastage Designer: Design & Development Datastage Admin: Installation & Configuration Datastage Architect: High Level design of Jobs & Implementing Standards (no idea ...

All,

when we use "Server job", i know there is an option to mention "Rows Per Transaction" to commit the transaction.

But i don't see that option in "Parallel job". is it because parallel job use the BULK COPY method?

Do documentation first. As soon as you create a new job, fill in its short and long description, the latter with the design intention. That means that anyone can take over the design if you can't get back to it. "Later" never happens when it comes to documentation. is there any standard t...

I got some useful info from the below URL.

http://it.toolbox.com/wiki/index.php/Da ... se_Edition


although if anybody wants to add some more points, it is always welcome!

Hi All,

I am sorry to ask this basic question. what is the difference between Enterprise edition (is nothing but parallel jobs. right? if yes, Please ignore my post) and server edition?

I have visited the below URL and came to know about http://it.toolbox.com/blogs/dw-soa/ibm-information-server-datastage-enterprise-edition-with-teradata-19417 DataStage (DS) has stages that allow you to use FastExport, MultiLoad, FastLoad and TPump. In addition, you can use the Teradata (TD) API sta...