A. Under Windows: Use the 'WaitForFileActivity' under the Sequencers and then run the job. May be you can schedule the sequencer around the time the file is expected to arrive.B. Under UNIX: Poll for the file. Once the file has start the job or sequencer depending on the file.

jyothi

• Mar 21st, 2006

Under Unix :what does Poll for file mean?.can u plz explain in detail

Answer Question  Select Best Answer

vvk.kotamraju

 Profile Answers by vvk.kotamraju Questions by vvk.kotamraju

• Mar 20th, 2006

Data Will transfer very quickly to the Data Warehouse by using SQL Loader.

RamaPrasad Batchu

• Mar 8th, 2006

When the source data is anormous or for bulk data we can use OCI and SQL loader depending upon the source

Answer Question  Select Best Answer

satheesh_color

 Profile Answers by satheesh_color Questions by satheesh_color

• Mar 15th, 2006

There are lot of Diffrences: There are lot of new stages are available in DS7.5 For Eg: CDC Stage Stored procedure Stage etc..

Answer Question  Select Best Answer

satheesh_color

 Profile Answers by satheesh_color Questions by satheesh_color

• Mar 15th, 2006

Hashed File is used for two purpose: 1. Remove Duplicate Records 2. Then Used for reference lookups.The hashed file contains 3 parts: Each record having Hashed Key, Key Header and Data portion.By using hashed algorith and the key valued the lookup is faster.

Answer Question  Select Best Answer

RamaPrasad Batchu

• Mar 10th, 2006

we can handle rejected rows in two ways with help of Constraints in a Tansformer.1) By Putting on the Rejected cell where we will be writing our constarints in the properties of the Transformer2)Use R...

satheesh_color

 Profile Answers by satheesh_color Questions by satheesh_color

• Mar 9th, 2006

We can handle by using constraints and store it in file or DB.

Answer Question  Select Best Answer

satheesh_color

 Profile Answers by satheesh_color Questions by satheesh_color

• Mar 9th, 2006

There are lot of Changes in DS EE. CDC Stage, Procedure Stage, Etc..........

Answer Question  Select Best Answer

Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance.   

RamaPrasad Batchu

• Mar 8th, 2006

We can also use the Hash File stage to avoid / remove dupilcate rowsby specifying the hash key on a particular fileld

Answer Question  Select Best Answer

Sharanu Patil

• Feb 28th, 2006

I think there is option to load DB2 database ,u just drag that & u can use it to load      or It is better to use ODBC .

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

You need to configure the ODBC connectivity for database (DB2 or AS400) in the datastage.

Answer Question  Select Best Answer

OCI means orabulk data which used client having bulk data its retrive time is much more ie., your used to orabulk data the divided and retrived

Sharanu Patil

• Feb 28th, 2006

OCI means oracle call interface i.e this acts like native tool to load oracle databaseU can just drag the oracle OCI from options and load

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

OCI doesn't mean the orabulk data. It actually uses the "Oracle Call Interface" of the oracle to load the data. It is kind of the lowest level of Oracle being used for loading the data.

Answer Question  Select Best Answer

Sharanu Patil

• Feb 28th, 2006

Its a critical question to answer, but one thing i can tell u that Datastage Tx is not a ETL tool & this is not a new version of Datastage 7.5.Tx is used  for  ODS source ,this much i know

Answer Question  Select Best Answer

Sharanu Patil

• Feb 28th, 2006

U can convert all hetrogenous sources into sequential files & join them using merge  orU can write user defined quey in the source itself to join them

Hameed

• Jan 12th, 2006

Yes you can extract the data from from two heterogenious sources in data stages using the the transformer stage it's so simple you need to just form a link between the two sources in the transformer stage that's itByeHameed

Answer Question  Select Best Answer

vedamurthy

• Feb 21st, 2006

hi,i am learnining datastage server job, but i dont have project to analyze, if u have any projects plz send it       gyvedamurthy@yahoo.co.in vedamurthy

Radhe

• Nov 18th, 2005

Performance and tuning of DS jobs:       1.Establish Baselines       2.Avoid the Use of only one flow for tuning/performance testing &n...

Answer Question  Select Best Answer

sekr

 Profile Answers by sekr Questions by sekr

• Jan 30th, 2006

data will partitioned on both the keys ! hardly it will take more for  execution .

Answer Question  Select Best Answer

sekr

 Profile Answers by sekr Questions by sekr

• Jan 30th, 2006

Can explain ! each of type where when and how to use.

Satheesh

• Jan 24th, 2006

Hai, These are the three different stages: i) Custom ii) Build iii) Wrapped

Answer Question  Select Best Answer

Goutham

 Profile Answers by Goutham Questions by Goutham

• Jan 26th, 2006

It is used to view and edit the contents of datastage repository.

prashanth

• Aug 25th, 2005

Datastage maneger is used to export and import purpose [/B] main use of export and import is sharing the jobs and projects one project to other project.  

Answer Question  Select Best Answer

Link Partitioner : It actually splits data into various partitions or data flows using various partition methods . Link Collector : It collects the data coming from partitions, merges it into a single data flow and loads to target. 

jagannimmagadda

 Profile Answers by jagannimmagadda Questions by jagannimmagadda

• Jan 10th, 2006

server jobs mainly execute the jobs in sequential fashion,the ipc stage as well as link partioner and link collector will simulate the parllel mode of execution over the sever jobs having single cpu L...

Answer Question  Select Best Answer

Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project. 

jagannimmagadda

 Profile Answers by jagannimmagadda Questions by jagannimmagadda

• Jan 10th, 2006

Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project. ? Ther...

Answer Question  Select Best Answer

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