Venkat

• May 22nd, 2006

This means try to improve the performance by avoiding use of constraints wherever possible and instead using them while selecting the data itself using a where clause. This improves performace.

Sharanu Patil

• Feb 28th, 2006

Constraints is nothing but restrictions to data.here it is restriction to data at entry itself , as he told it will avoid unnecessary data entry .

Answer Question  Select Best Answer

venkat

• May 22nd, 2006

Constraints are condition and once meeting those records will be processed further. Example process all records where cust_id0.Derivations are derived expressions.for example I want to do a SUM of Salary or Calculate Interest rate etc

Venkat

• May 22nd, 2006

Constraints are used to check for a condition and filter the data. Example: Cust_Id0 is set as a constraint and it means and only those records meeting this will be processed further.Derivation is a method of deriving the fields, for example if you need to get some SUM,AVG etc.

Answer Question  Select Best Answer

chereddy

 Profile Answers by chereddy Questions by chereddy

• May 18th, 2006

We have to create users in the Administrators and give the necessary priviliges to users.

Answer Question  Select Best Answer

chereddy

 Profile Answers by chereddy Questions by chereddy

• May 18th, 2006

The steps required are:select the datasource stage depending upon the sources for ex:flatfile,database, xml etcselect the required stages for transformation logic such as transformer,link collector,li...

Answer Question  Select Best Answer

silpabalram

• May 15th, 2006

You always enter DataStage through a DataStage project. When you start a DataStage client you are prompted to connect to a project. Each project contains:DataStage jobs. Built-in components. These are...

Answer Question  Select Best Answer

Sivarao

• May 15th, 2006

to develope scd type 2 us the update action in target as " insert new rows only"for this u need to maintain primary key as composite key in target table . it would be better to use timestamp column as one of key column in target table.

ramoojobs

 Profile Answers by ramoojobs Questions by ramoojobs

• Apr 20th, 2006

We can handle SCD in the following ways            Type 1: Just use, ?Insert rows Else Update rows?       &nbs...

Answer Question  Select Best Answer

Ankit Agrawal

• May 13th, 2006

There are four client components DataStage Designer. A design interface used to create DataStage applications (known as jobs). Each job specifies the data sources, the transforms required, and the des...

Answer Question  Select Best Answer

pavan

• May 13th, 2006

ORABULK is used to load bulk data into single table of target oracle database.BCP is used to load bulk data into a single table for microsoft sql server and sysbase.

ragkris

• Mar 1st, 2006

these are called as pilu-in stages orabulk is used when v have bulk data in oracle then v go for orabulk for other than oracle database v go for bcp stages.if u have any doubts feel free to mail me at letter4raghu@yahoo.co.in

Answer Question  Select Best Answer

ashok

• May 9th, 2006

file extender means the adding the columns or records to the already existing the file, in the data stage,we can run the data stage job from one job to another job in data stage.

Answer Question  Select Best Answer

madan

• Apr 29th, 2006

Merge stage in used for only Flat files in server edition

Sharanu Patil

• Feb 28th, 2006

I think above answer is more then enough

Answer Question  Select Best Answer

ramoojobs

 Profile Answers by ramoojobs Questions by ramoojobs

• Apr 21st, 2006

Complex file and Surrogate key generator stages are added in Ver 7.5    

srinivas

• Apr 14th, 2006

As of my knowledge the main enhancement i found is we can generate reports in 7.5 where u can't in 7.0and also we can import more plug-in stages in7.5

Answer Question  Select Best Answer

ramoojobs

 Profile Answers by ramoojobs Questions by ramoojobs

• Apr 21st, 2006

U can view all the environment variables in designer. U can check it in Job properties. U can add and access the environment variables from Job properties

srinivas

• Apr 14th, 2006

u can call it in designer windowunder that job propertiesthere u can add an new environment variable r u can use the existing one

Answer Question  Select Best Answer

ramoojobs

 Profile Answers by ramoojobs Questions by ramoojobs

• Apr 21st, 2006

Oracle offers a proprietary call interface for C and C++ programmers that allows manipulation of data in an Oracle database. Version 9.n of the Oracle Call Interface (OCI) can connect and process SQL ...

suresh

• Apr 6th, 2006

Oracle Call level Interface

Answer Question  Select Best Answer

ramoojobs

 Profile Answers by ramoojobs Questions by ramoojobs

• Apr 21st, 2006

We can use DataStage Extract Pack for SAP R/3 and DataStage Load Pack for SAP BW to transfer the data from oracle to SAP Warehouse. These Plug In Packs are available with DataStage Version 7.5

Answer Question  Select Best Answer

satish kumar

• Apr 16th, 2006

hicontainers r speacial type of jobs in the datastage that will simplify the job design either in the server or parallel jobs.2 types of containers1.Local containers2 shared containers   Loc...

mallakishore

 Profile Answers by mallakishore Questions by mallakishore

• Oct 20th, 2005

There are Two types of containers1.Local Container2.Shared ContainerLocal container is available for that particular Job only.Where as Shared Containers can be used any where in the project.Local cont...

Answer Question  Select Best Answer

?

sekr

 Profile Answers by sekr Questions by sekr

• Apr 14th, 2006

if  ur system is mainfarmes then u can utility called load and unload ..load will load the records into main farme systme from there u hv to export in to your system ( windows)

Sharanu Patil

• Feb 28th, 2006

U can use DB2 stage to implement this

Answer Question  Select Best Answer

aranjan

 Profile Answers by aranjan Questions by aranjan

• Apr 5th, 2006

Hi,   I think we can call a job into another job. In fact calling doesn't sound good, because you attach/add the other job through job properties. In fact, you can attach zero or more jobs. ...

Sonal

• Mar 21st, 2006

Hi,We cannot call one job within another in DataStage, however we can write a wrapper to access the jobs in a stated sequence.We can also use sequencer to sequence the series of jobs.

Answer Question  Select Best Answer

rajshankar_s

 Profile Answers by rajshankar_s Questions by rajshankar_s

• Apr 4th, 2006

U can create a UNIX shell script which will pass the parameters to the job and u also can create logs for the whole run process of the job.

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

You can do this, by passing parameters from unix file, and then calling the execution of a datastage job. the ds job has the parameters defined (which are passed by unix)

Answer Question  Select Best Answer

jagannimmagadda

 Profile Answers by jagannimmagadda Questions by jagannimmagadda

• Mar 28th, 2006

By using This User variable activity we can create some variables in the job sequnce,this variables r available for all the activities in that sequnce.Most probablly this activity is @ starting of the job sequnce

Answer Question  Select Best Answer

raj

• Mar 24th, 2006

Hi all, Can any one please explain the difference between GENERAL and SEQ.NUM hashiing algorithms? thanks in advanceraj

rajarajana

 Profile Answers by rajarajana Questions by rajarajana

• Mar 23rd, 2006

A hashing algorithm takes a variable length data message and creates a fixed size message digest.When a one-way hashing algorithm is used to generate the message digest the input cannot be determined ...

Answer Question  Select Best Answer