rajshankar_s

 Profile Answers by rajshankar_s Questions by rajshankar_s

• Apr 4th, 2006

U can create a UNIX shell script which will pass the parameters to the job and u also can create logs for the whole run process of the job.

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

You can do this, by passing parameters from unix file, and then calling the execution of a datastage job. the ds job has the parameters defined (which are passed by unix)

Answer Question  Select Best Answer

jagannimmagadda

 Profile Answers by jagannimmagadda Questions by jagannimmagadda

• Mar 28th, 2006

By using This User variable activity we can create some variables in the job sequnce,this variables r available for all the activities in that sequnce.Most probablly this activity is @ starting of the job sequnce

Answer Question  Select Best Answer

raj

• Mar 24th, 2006

Hi all, Can any one please explain the difference between GENERAL and SEQ.NUM hashiing algorithms? thanks in advanceraj

rajarajana

 Profile Answers by rajarajana Questions by rajarajana

• Mar 23rd, 2006

A hashing algorithm takes a variable length data message and creates a fixed size message digest.When a one-way hashing algorithm is used to generate the message digest the input cannot be determined ...

Answer Question  Select Best Answer

shameerok

• Mar 22nd, 2006

If Hash file output is connected to transformer stage the hash file will consider as the Lookup file if there is no primary link to the same Transformer stage, if there is no primary link then this wi...

Sharanu Patil

• Feb 28th, 2006

If u connect output of  hash file to transformer ,it will act like reference .there is no  errores at all!! It can be used in implementing SCD's

Answer Question  Select Best Answer

Merge is nothing but a filter conditions that have been used for filter condition

shameerok

• Mar 22nd, 2006

Merge stage is a processing stage, it can have any no of input link and only one output link. It is having master data set and one or more data sets. The out put of the Merge stage is master dataset p...

Sharanu Patil

• Feb 28th, 2006

Merge is maily used to join two flat or sequential files in server jobs

Answer Question  Select Best Answer

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