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

Currently, the total is converted to ASCII, even tho the individual records are stored as EBCDIC.

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

rajenmari

 Profile Answers by rajenmari Questions by rajenmari

• Mar 26th, 2007

Routine : Routine is like procedure which is called to process certain operation.GoSub ADD(A,B)ADD(A,B):C=A+Breturn C

shiva

• Jun 29th, 2006

HiTransformers are used to transform the data from one from to other form where as routines are used to implement the business logic

Answer Question  Select Best Answer

rajenmari

 Profile Answers by rajenmari Questions by rajenmari

• Mar 26th, 2007

In ODBC propertiesClick on OUTPUT General select  Stored Procedurebrowse to get the stored procedure if have not import then you need to import it.try this if still have problem buzz me.Raj Reddy

Answer Question  Select Best Answer

rajenmari

 Profile Answers by rajenmari Questions by rajenmari

• Mar 26th, 2007

Use Stage variable to set variable in transformation properties.where you set user definied variable.reddy

Answer Question  Select Best Answer

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 21st, 2007

Here is the full FAQ on this topic:Creating project specific environment variables- Start up DataStage Administrator.- Choose the project and click the "Properties" button.- On the General tab click t...

yukthi

• Oct 13th, 2006

Thanx

Answer Question  Select Best Answer

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 20th, 2007

Transformer stage to identify and remove duplicates from one output, and direct all input rows to another output (the "rejects"). This approach requires sorted input.

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 20th, 2007

This is questions has got more answers as the elimination od duplicates are situation specific. Depending upon the siutation we can use the best choice to remove duplicates.1. Can write a SQL qurey de...

Answer Question  Select Best Answer

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 19th, 2007

For every job in DataStage, a phantom is generated for the job as well as for every active stage which contributes to the job. These phantoms writes logs reg the stage/job. If there is any abnormality...

ATTILI

• Mar 19th, 2007

For every job in DataStage, a phantom is generated for the job as well as for every active stage which contributes to the job. These phantoms writes logs reg the stage/job. If there is any abnormality...

Answer Question  Select Best Answer

raghumreddy

• Mar 14th, 2007

Enviroment Variables are the one who set the enviroments.Oce you set these varicables in datastage you can use them in any job as a perameter.Example is you you want to connect to database you need us...

kumar

• Mar 6th, 2007

Environment variables are predefined variable those we can use while creating datastage jobs.We can set in project level or job level once we set the variable the variable will be available in the project.

Answer Question  Select Best Answer

raghumreddy

• Mar 14th, 2007

DSJOB Command is the command to run the datastage jobs from command line . in the older architectures people use to create the Batchjob to control the remaining datastage jobs in the process in KEN BL...

Answer Question  Select Best Answer

raghumreddy

• Mar 14th, 2007

In a star schema there will be facts and dimension tables to load  in any datawarehouse environments. You will generaly load the Dimension tables first and then Facts.Facts will have the relative information of dimension.HTHThanksRaghu Mule

Ramesh Chandra yadav

• Mar 9th, 2007

You load the facts table in the data mart with the combined input of ODBC (OR DSE engine) data sources. You also create transformation logic to redirect output to an alternate target, the REJECTS table, using a row constraint.

Answer Question  Select Best Answer

raghumreddy

• Mar 14th, 2007

If the datais large and if you cannot process the the full data in one time process you will generally use the Range partitioning.HTHThanksRaghu Mule

uk5673

• Mar 5th, 2007

It is used when Data Volumn Is high.It's Partitioning by Column wise.

Answer Question  Select Best Answer