guess

• Sep 21st, 2006

There are three processes start when the DAtastage engine starts:1. DSRPC2. Datastage Engine Resources3. Datastage telnet Services*************************************************

Answer Question  Select Best Answer

Kiran

• Nov 2nd, 2006

The Surrogate key will be the key field in the dimensions.

Answer Question  Select Best Answer

How to design a job with incremental loading in datastage?

Divya

• Jul 14th, 2011

There are ways to perform the incremental load. While performing incremental load Pls take care of below points: 1. Retrieve changed records from last load run from source by using appropriate extract...

Answer Question  Select Best Answer

How to find job endtime?

j.padma89

 Profile Answers by j.padma89 Questions by j.padma89

• Jul 14th, 2011

Job end time can be found in Director > job log

Answer Question  Select Best Answer

How do we pass parameters from UNIX? & How do we pass parameters by using UNIX shell scripting?

mcrao1

 Profile Answers by mcrao1 Questions by mcrao1

• Jul 11th, 2011

Hi Amulaswe can pass parameter in UNIX command by using '-PARAM'.syntax:???? -PARAM parameter_name %parameter value%Example:??? -PARAM business_date %20110711%??????RegardsChalapathirao.MHCL Technologies( Malaysia)+60182296096.

Answer Question  Select Best Answer

source has 10000 records, Job failed after 5000 records are loaded. This status of the job is abort , Instead of removing 5000 records from target , How can i resume the load

Raghu

• Aug 1st, 2007

There are lot of ways of doing this.But we keep the Extract , Transform and Load proess seperately.Generally only load job never failes unles there is a data issue.All data issues are cleared bef...

Answer Question  Select Best Answer

csri2006

 Profile Answers by csri2006 Questions by csri2006

• Jan 31st, 2008

In what database is the stored procedure located. If it is Oracle stored procedure, you can use "stored procedure stage" in DataStage 7.5.Hope this helps. Srinivas

Answer Question  Select Best Answer

nagakalyan

 Profile Answers by nagakalyan Questions by nagakalyan

• Jun 23rd, 2008

Lookup we can set condition option otherwise then reject records enter into target we can direct load data what ever it may be load and create

Answer Question  Select Best Answer

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Apr 8th, 2010

There is a parameter called RTLogging and ORLogging in DSParams file for every project.The default value is :RTLogging=1ORLogging=0 If you change the value to following in DSParams file:RTLogging =0 ORLogging=1 then the log will not appear in Datastage Director. 

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

vujjini1974

 Profile Answers by vujjini1974 Questions by vujjini1974

• Sep 30th, 2009

There is only one look up stage in parallel extender, and it is of two types one is normal look up and another one is Sparse look up,mostly we normal look up for the reference datasets.

Answer Question  Select Best Answer

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 19th, 2010

There are two ways of specifying where the Hash Files will be created.a) Account : This is generally the project name.If this is selected,the Hash file will be generated in the hash file path specific...

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

Job control specially used to control the job, means through this we can pass the parameters, some conditions, some log file information, dashboard information, load recover etc...,job seq is used to ...

Answer Question  Select Best Answer

Raghu

• Aug 1st, 2007

Type30 Files are Dynamic files.HTHRaghu Mule

Answer Question  Select Best Answer

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 18th, 2010

Datastage is platform independent.A same job,when designed properly can run on SMP as well as MPP systems.Partitioning does not need to be changed for SMP/MPP systems.

Answer Question  Select Best Answer

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Nov 29th, 2009

It seems you are asking for APT_DUMP_SCORE.It can be configured through datastage administrator->Environment variables.

Answer Question  Select Best Answer

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 22nd, 2010

It is 127.0.0.1

Answer Question  Select Best Answer

Orchestrate itself is an ETL tool with extensive parallel processing capabilities and running on UNIX platform. Datastage used Orchestrate with Datastage XE (Beta version of 6.0) to incorporate the parallel processing capabilities. Now Datastage has purchased Orchestrate and integrated it with Datastage XE and released a new version Datastage 6.0 i.e Parallel Extender. 

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 17th, 2010

Already answered in the question itself.

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

Hashed File is classified broadly into 2 types. a) Static - Sub divided into 17 types based on Primary Key Pattern. b) Dynamic - sub divided into 2 types     i) Generic    ii) Specific. Default Hased file is "Dynamic - Type Random 30 D" 

prashanth

• Aug 25th, 2005

Hashed File is classified broadly into 2 types.   a) Static - Sub divided into 17 types based on Primary Key Pattern.  b) Dynamic - sub divided into 2 types   i) Generic   ii) Specific.   Default Hased file is "Dynamic - Type30.  

chennu rajesh

• Jul 7th, 2005

Please give the different of dynamic hashf iles in detail

Answer Question  Select Best Answer