DSXchange

You mean RSS Feed available in Browsers

Have you tried just SELECT SCHEMA.TABLE1.FIELD1 ABC.....
What is your job desing. If you have any transformer or modify or any other stage which aids renaming the column, you can do it before joining the columns in Join stage.

If you find your topic is resolved, pls close it.

Hi Vinay,
Welcome to DsXchange :D !!!!
Is it with Source are target? Its its with source and if the issue is with Datastage jobs, you can extract and change the name of the columns later in the stages. You need to explain in bit more detailed manner on you design of you job.

If the duplicates are less in numbers, If performance is only criteria i would suggest, use KeyChangeCol and filter those rows into a seperate file. And later delete the rows for which the key are available in the rejected file. Which will be less in numbers. For simple construction, opt first appro...

As mentioned PC016989 in 17CC1E71-9657-499F-8B42-24C45F3B54CD-PC016989:29230 is your client computer name. So find the distinct of the client connected to get your requirement.

Hi Varun,
Those pdf will be available only if training are attended. But you should be able to make it up with the pdf that are available in the client (Online manuals) or in the software CD.

Yes in stored procedure and queries that been called by Datastage.

Protected and Readonly are different parameters. If you have promoted your jobs form Version control as Readonly mode you might get this effect. You can reimport with Non readonly mode. Alternativly you can execute the follwing command in the Command option available in Datastage administrator UPDAT...

Well search will give you full details.
From the Command option available in Adminstrator use

You are going to conduct or attend?
If you have already attended the IBM course, you can use the student materials. Else the available pdf and this site will give you lot more information.

Search on these topic will result large number of posts. A unique id that need required to run the multiple instance job parallel. Say for example if you pass INV1 as invocation id to a job JOB1, you can find a seperate entry for a JOB1.INV1 in datastge director. Using Batch jobs you can call the ot...

The timeouts will be more on Database end. For those query which runs beyond certain timeframe will be terminated by the Database. You DBA should take care of this issue as well. Many erros like ORA-03114,ORA-1555... might cause due to the long running query.

There are many ways to do this. Surrogate key gen can be used. Manual key can also be generated using @INROWNUM/@OUTROWNUM function. For the second requirement, you can additionally do a Max(Key) from the target and assign to a file or to a UserStaus. And pass it as a parameter to the next job. You ...

SIGINT is the signal thrown by a computer program when a user wishes to interrupt a process. This has been dealt many times in this forum. Most likely resulting in extreme resource consumptions. Leading to increasing resource or decreasing the demand for the resource.