Raghu

• Aug 1st, 2007

Aggrigator cannot store the data onto disk like Sortstage Do the data landing.your system memory will be occupied by the data that is going to aggrigator.If your system memory is full then you get tha...

Answer Question  Select Best Answer

Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values. Dimension table - Table with Unique Primary Key. Load - Data should be first loaded into dimensional table. Based on the primary key values in dimensional table, the data should be loaded into Fact table.

Siraj

• Aug 3rd, 2007

__________________                       _______________     _________...

sriram

• May 24th, 2007

When does ODS come in to picture ?I guess its like this                        &...

Answer Question  Select Best Answer

Mobashshar

• Aug 8th, 2007

What type of index are you looking for ? If it is only based on rows, use @inrownum or @outrownum

Answer Question  Select Best Answer

Adam

• Sep 17th, 2007

It's very difficult to have a good usgae analysis in oracle and see exactly who is touching what and how on table and column level. However I know that there is a good tool called DB*Classify that pro...

Answer Question  Select Best Answer

prasoon.pandey

 Profile Answers by prasoon.pandey Questions by prasoon.pandey

• Sep 18th, 2007

This only appears if the job identified by Job Name has Allow Multiple Instance enabled. Enter a name for the invocation or a job parameter allowing the instance name to be supplied at run timeAn '...

Answer Question  Select Best Answer

parvathi

• Oct 2nd, 2007

Create a shell script like stg.sh and declare needed parameters for source and schema and target in run_dsjob program. Remember the parameters you used for script should be declared at source and target and give all parameters and job name all as parameters to run_dsjob.

subbu malepati

• Sep 3rd, 2006

Hi,use cmd line options../shellscript in the script use $1, $2 ... etc as arguments.regardsSubbu MalepatiBlore.

Answer Question  Select Best Answer

parvathi

• Oct 2nd, 2007

Not clear with question. But you cannot directly link seq.file to other seq.file. you can give the link as?a reject link but no data will carry thru link.

Answer Question  Select Best Answer

vijay

• Nov 4th, 2007

 by using lookup stage and change capture stage we will implement the  scd.   we have 3 types of scds   type1:it will maintain the current values only.   type2:...

suganyasug

• Apr 18th, 2007

We can implement SCD in datastage 1.Type 1 SCD:insert else update in ODBC stage2.Type 2 SCD:insert new rows if the primary key is same and update with effective from date as JobRundate and to date to ...

Answer Question  Select Best Answer

Gnaneshwar

• Nov 21st, 2007

You have to install Windows 2003 Server enterprise edition with SP2 or more and .Net framework for Datastage PX or Unix OS. If you have installed on Win XP it wont work properly. For Datastage TX you can install on Windows XP

vijay palreddy.

• Oct 30th, 2007

Do the steps in order:1) create user account and password in user accounts2)install data stage sever3)install clientit works..imp: ur installation drive should be in NTFS not FAT32.

Answer Question  Select Best Answer

Pl send material for data stage

ajaygosh

 Profile Answers by ajaygosh Questions by ajaygosh

• Dec 8th, 2007

Here is a good link by Joshy George on this. DataStage Parallel routines made really easyhttp://blogs.ittoolbox.com/dw/soa/archives/datastage-parallel-routines-made-really-easy-20926

sivarao

 Profile Answers by sivarao Questions by sivarao

• Dec 28th, 2005

there are 3 kind of routines is there in Datastage.1.server routines which will used in server jobs.    these routines will write in BASIC Language2.parlell routines which will used in ...

Answer Question  Select Best Answer

sunayan

 Profile Answers by sunayan Questions by sunayan

• Dec 13th, 2007

A job can be made read only by the follwing process:Export the job in the .dsx format and change the attribute which store the readonly information from 0 ( 0 refers to editable job) to 1 ( 1 refer to...

Gnaneshwar

• Nov 21st, 2007

By creating Protected Project. In Protected Project all jobs are read only. You cant modify the job. If you modify that job it will not effect the job.

Answer Question  Select Best Answer

Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be allocated for both type of lookups?

harishsj

 Profile Answers by harishsj Questions by harishsj

• Jan 22nd, 2008

"Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be ...

Answer Question  Select Best Answer

To run Job why do we use only even number nodes like 2,4,6,8.., Why don't we use 1,3,5..,?

anshulsri2

 Profile Answers by anshulsri2 Questions by anshulsri2

• Jan 23rd, 2008

There are no odd number nodes used in datastage, for the simple reason we are not allowed to configure odd number nodes on the datastage server.

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

Sequential file can used as a target file but Dataset can't be used as final target, it can be used as temperary target.Dataset can be used as a hashfile(just like in server hashfile), it improves...

vijaykumar_ads

 Profile Answers by vijaykumar_ads Questions by vijaykumar_ads

• Jan 18th, 2008

Parallel jobs use data sets to manage data within a job. You can think of each link in a job as carrying a data set. The Data Set stage allows you to store data being operated on in a persistent form,...

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

Here in server we have to use some stages like link partitioner, link coll, inter process.. to implement ll'lism. And sometimes we have to use lot of stages to implement specific logic bcoz of&nbs...

sanchit_states

 Profile Answers by sanchit_states Questions by sanchit_states

• Jan 18th, 2008

Server jobs while using look up converts code into .osh languagewhile Parallel converts the code in C++ code ..leading to the req of VC++ compiler.

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

Here in datastage there are some warnings and some fatal errors will come in the log file.  If there is any fatal error means the job got aborted but if there are any warnings are there mean...

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

I think there is no version like standard Ascential DataStage 7.5, I know only the advanced edition of Datastage i.e., only web sphere Datastage and Quality stage, it is released by IBM itself and giv...

vsingh

 Profile Answers by vsingh Questions by vsingh

• Jan 23rd, 2008

IBM Information Server also known as DS 8 has more features like Quality Stage & MetaStage . It maintains its repsository in DB2 unlike files in 7.5. Also it has stage specifically for SCD 1 & 2.

Answer Question  Select Best Answer

i am running huge amount of data through a sort stage and it is very slow. Is there any option which can increase the performance with in the sort stage?

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

See if it is orcle db then u can write user def query for sort and remove duplicates in the source itself. and maintaining some key partition teqniques u can improve the performence. If it is not the ...

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

nagarajhrr

 Profile Answers by nagarajhrr Questions by nagarajhrr

• Jan 28th, 2008

Hi just u install client/server , after that u install .net to support c++ thats very imp to parallel extender project, after  u install vb.net then u try to start , i u run datastage adminstrato...

Answer Question  Select Best Answer