DSXchange

Without identifying the particular post to which he (?) was referring I KNOW THAT ,THIS IS ONE OF THE INTERVIEW QUESTION ,IF U KNOW PLS HELP ME We at DSXchange do not, as a matter of policy, provide answers to interview questions. We believe that interview question answers should be those of the can...

Try putting the file somewhere else. "False" may be a reserved word.

Or, of course, increase the available resources (buy hardware). The experience with version 8 seems to be more and more that the development machine needs at least as much grunt as the production machine, particularly when there are multiple developers. It's a simple supply and demand situation. Use...

What do you need in the header/footer? Is there only one per file, or is there one per group of records? What, indeed, do you mean by these terms in an XML context? For single header/footer the simplest method is to use an echo command. More complex header/footer may be written with before/after sub...

It's not possible to access UniVerse from parallel jobs unless (a) it's genuine UniVerse (not DataStage) and (b) you have an ODBC driver for UniVerse installed on the DataStage server. In a parallel job there is no direct way to access the tables in the DataStage Repository. You could, of course, cr...

Anything in the DB2 logs (for example duplicate key errors)?

Stored in records in the RT_STATUSnnn table for the job, where the job number is nnn. There is no documentation in the public domain that explains the structures that are used - as Craig says you're better off using API functions, mainly DSGetLinkInfo(), to retrieve this information.

adisheshu.dwh wrote:using transformer stage not aggregator stage

Why? Give me a good reason not to use the right tool for the job.

1. Obtain the requirement. 2. Design the algorithm, considering other possibilities and documenting why you made particular choices. Design test data. 3. Convert your specification into DataStage BASIC code in a new Routine of the appropriate type. 4. Compile the routine. Fix the first error and re-...

Interview question?

U could do incremental aggregation in precisely the same way that anyone else can.

However, I happen to know that U is presently working on a server-only site, and is therefore unlikely to be able to provide an answer for parallel job execution.

Have you re-started DataStage server after emplacing the new map? One of the things done when the server starts is to load selected maps into shared memory. Have you used the Administrator client to mark the map as one of those to be loaded?

VOC is a hashed file containing the "vocabulary" for a project. TCL stands for "terminal control language", the language used for interactive interaction with the DataStage shell dssh. TCLcomand is merely the name of a variable in the code and doesn't really "mean" anyt...

How do you (sorry, u) use SMS-style abbreviations in an inteview?

Well don't use them here!

I don't believe U is working on a site where they have Teradata. Therefore it is unlikely that U will be able to tell you how to achieve this. The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on ...

I don't think you're supposed to be able to delete Information Analyzer jobs.