suman

• Jul 8th, 2007

Hi madhavi,Type host name in the dos you will get system host name type as it is,if the problem is not solved then go to my computer Properties and change the computer name may be it will work and whi...

Manjunath

• May 21st, 2007

Hi Madhavi,Give the hostname as .(dot) and give the username and password ...then it will work.RegardsManju

Answer Question  Select Best Answer

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 8th, 2007

You can insert the parameter values in a table and read them when the package runs using ODBC Stage or Plug-In stage and use DS variables to assign them in the data pipeline, or pass the par...

malneedi

 Profile Answers by malneedi Questions by malneedi

• Sep 29th, 2005

Two ways1. Ste the default values of Parameters in the Job Sequencer and map these parameters to job.2. Run the job in the sequencer using dsjobs utility where we can specify the values to be taken for each parameter.

Answer Question  Select Best Answer

gadwalvr

 Profile Answers by gadwalvr Questions by gadwalvr

• Jun 25th, 2007

The question itself is a little ambiguous to me. I think the answer to the question might be, we will place some conditions like 'where' inside the OCI stage and the rejected rows can be obtai...

Answer Question  Select Best Answer

ajinkyac

 Profile Answers by ajinkyac Questions by ajinkyac

• Jun 16th, 2007

1. if u need to capture mismatches between the two sources, lookups provide easy option

bhaskar jha

• May 16th, 2007

If the volume of data is high then we should use Join stage instead of Lookup.

Answer Question  Select Best Answer

ajinkyac

 Profile Answers by ajinkyac Questions by ajinkyac

• Jun 16th, 2007

You can use change-capture & change apply stages for this

Answer Question  Select Best Answer

Raghu

• Jun 13th, 2007

$PROJDEF?parms are?project level parameters. You can assign a value to them in Administrator and use as #$#. You can also create user defined parms at project level and use them also.

Answer Question  Select Best Answer

As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size.

klsrao

 Profile Answers by klsrao Questions by klsrao

• Jun 12th, 2007

Good explanation.

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 8th, 2007

Dynamic Hash Files can automatically adjust their sie - modulous (no. of groups) and separation (group size) based on the incoming data. Type 30 are dynamic. Static files do not adjust their modulous ...

Answer Question  Select Best Answer

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 10th, 2007

There is a lock for update option in Hashed File Stage, which locks the hashed file for updating when the search key in the lookup is not found.

Sharanu Patil

• Feb 28th, 2006

Question is not clear still, i think 'insert to update' is updated value is inserted to maintain  history

Answer Question  Select Best Answer

Either used Copy command as a Before-job subroutine if the metadata of the 2 files are same or created a job to concatenate the 2 files into one if the metadata is different.

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 8th, 2007

Use the merge plug-in stage which can merge two files based on the defined key fields by using, INNER or OUTER joins, UNION, Intersection or Minus operations.

hanug

 Profile Answers by hanug Questions by hanug

• May 7th, 2007

We can use either FUNNEL stage or use the sequentil stage and read more then one file(both files format should be same). Hanu.

Answer Question  Select Best Answer

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 8th, 2007

U can call external functions, subroutines by using Before/After stage/job Subroutines : ExecSHExecDOSor By using Command Stage Plug-In or by calling the routine from external command activity from Job Sequence.

Mujeebur

• Jul 22nd, 2005

There is datastage option to call external programs . execSH

Answer Question  Select Best Answer

Parallel Processing is broadly classified into 2 types. a) SMP - Symmetrical Multi Processing. b) MPP - Massive Parallel Processing. 

Gary

• May 7th, 2007

Hardware wise there?are?3 types of parallel processing systems available:1. SMP (symetric multiprocessing: multiple CPUs, shared memory, single OS)2. MPP (Massively Parallel Processing Systems: mult...

jemelyn binay

• Aug 11th, 2006

What are the types of parallel processing?Differentiate?

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 7th, 2007

It is primarily used to create the Datastage project, assign the user roles to the project, set parameters of the jobs at project level. Assign the users to the project can also be done here.Hanu.

CNU

• Aug 2nd, 2005

The Administrator enables you to set up DataStage users, control the purging of the Repository, and, if National Language Support (NLS) is enabled, install and manage maps and locales. 

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 7th, 2007

The Question asked incorrectly.there wont be any Oracle file. It is Oracle table or view object.I never heard about Oracle input file.Can you please explain what your actual question is?Hanu.

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 7th, 2007

1. Define the job parameter at the job level or Project level.2. Use the file name in the stage(source or target or lookup)3. supply the file name at the run time.Hanu.

sridhar245

 Profile Answers by sridhar245 Questions by sridhar245

• Nov 28th, 2005

1. Go to DataStage Administrator->Projects->Properties->Environment->UserDefined. Here you can see a grid, where you can enter your parameter name and the corresponding the path of the fil...

Answer Question  Select Best Answer

Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition like Hash, DB2, Random etc..While using Hash partition we specify the Partition Key. 

hanug

 Profile Answers by hanug Questions by hanug

• May 7th, 2007

Hi:Primary key is the key we define on the table column or set of columns(composite pk) to make sure all the rows in a table are unique.Partition key is the key that we use while partition the table(i...

Answer Question  Select Best Answer

Data in a Database is a) Detailed or Transactional b) Both Readable and Writable. c) Current.

bhargava

• May 1st, 2007

Database data is in the form of OLTP and Data warehouse data will be in the form of OLAP. OLTP is for transactional process and OLAP is for Analysis purpose.

Ravi B

• Mar 30th, 2005

By Database, one means OLTP (On Line Transaction Processing). This can be the source systems or the ODS (Operational Data Store), which contains the transactional data.

Answer Question  Select Best Answer

suganyasug

• Apr 18th, 2007

By using Routines we can return values but by transformers we cannot return values

john daniel

• Nov 7th, 2006

Difference between Routiens and Transformer is that both are same to pronounce but Routines describes the Business logic and Transformer specifies that transform the data from one locat...

Answer Question  Select Best Answer

suganyasug

• Apr 18th, 2007

Qulaity Stage can be integrated with DataStage, In Quality Stage we have many stages like investigate, match, survivorship like that so that we can do the Quality related works and we can integrate with datastage we need Quality stage plugin to achieve the task.

sekr

 Profile Answers by sekr Questions by sekr

• Jun 8th, 2006

could you please expalin in detail what excatly quality stagestage,auditstage,profilestage used in datastage and where it is used in datastage .thanks in adv.

Answer Question  Select Best Answer

Gnaneshwar

• Apr 9th, 2007

Oracle 8i does not support pseudo column sysdate but 9i supportsOracle 8i we can create 256 columns in a table but in 9i we can upto 1000 columns(fields)

Venkat

• Oct 3rd, 2005

Ramanam.v Wrote: mutliproceesing,databases more dimesnionsal modeling

Answer Question  Select Best Answer

rajenmari

 Profile Answers by rajenmari Questions by rajenmari

• Mar 26th, 2007

What type of error dud you got.explain error.

Answer Question  Select Best Answer