Speed

• Jan 7th, 2006

Row Merger, Row splitter are only present in parallel Stage .

bvrp

 Profile Answers by bvrp Questions by bvrp

• Dec 19th, 2005

? DataStage Standard Edition was previously called DataStage and DataStage Server Edition. ? DataStage Enterprise Edition was originally called Orchestrate, then renamed to Parallel Extender when purc...

Answer Question  Select Best Answer

Sivarao

• Dec 27th, 2005

Incremental load means daily load.when ever you are selecting data from source, select the records which are loaded or updated between the timestamp of lastsuccessful load and todays load start date a...

Dimple

• Dec 5th, 2005

You can create a table where u can store the last successfull refresh time for each table/Dimension.Then in the source query take the delta of the last successful and sysdate should give you incremental load.

Answer Question  Select Best Answer

Yes. One of the most important requirements.     

sekr

 Profile Answers by sekr Questions by sekr

• Dec 10th, 2005

some times u need to write unix progrms in back round !like batch progms ! bcz data stage can invoke a batch processing in every 24 hrs .soo.......unix must... so that we can run the unix prog in back round even min/ hrs

Answer Question  Select Best Answer

Raghu

• Dec 9th, 2005

APT_CONFIG is just an environment variable used to idetify the *.apt file. Dont confuse that with *.apt file that has the node's information and Configuration of SMP/MMP server.

shiva

• Dec 7th, 2005

Datastage understands the architecture of the system through this file(APT_CONFIG_FILE). For example this file consists information  of node names, disk storage information...etc.

Answer Question  Select Best Answer

Venkat

• Oct 25th, 2005

Dear User. A datawarehouse is a repository(centralized as well as distributed) of Data, able to answer any adhoc,analytical,historical or complex queries.Metadata is data about data. Examples ...

Answer Question  Select Best Answer

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

Datastage jobs are executed in the server machines only. There is nothing that is stored in the client machine.

Answer Question  Select Best Answer

mallakishore

 Profile Answers by mallakishore Questions by mallakishore

• Oct 20th, 2005

Actually the Number of Nodes depend on the number of processors in your system.If your system is supporting two processors we will get two nodes by default.

sekhar

• Oct 11th, 2005

Default nodes is allways one

Answer Question  Select Best Answer

Give the OS of the Server and the OS of the Client of your recent most project

rcp

• Oct 13th, 2005

Server is unix and client machine i.e is ur machine where u design a job is windows xp professional

Answer Question  Select Best Answer

malneedi

 Profile Answers by malneedi Questions by malneedi

• Sep 29th, 2005

. Join and look up used to join oracle and sequential file

Answer Question  Select Best Answer

Suppose job sequencer synchronies or control 4 job but job 1 have problem, in this condition should go director and check it what type of problem showing either data type problem, warning massage, job fail or job aborted, If job fail means data type problem or missing column action .So u should go Run window ->Click-> Tracing->Performance or In your target table ->general -> action-> select this option...

sekhar

• Sep 15th, 2005

Datastage developer is one how will code the jobs.datastage designer is how will desgn the job, i mean he will deal with blue prints and he will design the jobs the stages that are required in developing the code

Answer Question  Select Best Answer

narsimhulu.D

• Sep 11th, 2005

Using Orabulk

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

CNU

• Aug 2nd, 2005

You use the Designer to build jobs by creating a visual design that models the flow and transformation of data from the data source through to the target warehouse. The Designer graphical interface lets you select stage icons, drop them onto the Designer work area, and add links. 

Answer Question  Select Best Answer

Yes. The following are some of the steps; I have taken in doing so:1) Definitely take a back up of the whole project(s) by exporting the project as a .dsx file2) See that you are using the same parent folder for the new version also for your old jobs using the hard-coded file path to work.3) After installing the new version import the old project(s) and you have to compile them all again. You can use...