On the scale of 1-10 say 8.5-9 

padmanabhan.s

 Profile Answers by padmanabhan.s Questions by padmanabhan.s

• Jul 29th, 2008

Though we dont write the PL/SQL directly, we can write a procedure or a fucntion which determines our needs and then can be called in the datastage ODBC or OCI stage using call() statement. For eg. if...

sekr

 Profile Answers by sekr Questions by sekr

• Jan 31st, 2006

U will not be writtinf pl/sql in datastage ! sql knowledge is enough ...

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

lakshmib

 Profile Answers by lakshmib Questions by lakshmib

• Sep 24th, 2008

It is a runtime parameter which allows you to enter the value to restrict the data at the job run time. A job parameter is created with name,promt,data type,default value,and it is reprsented as follows #parameter name#.

mallakishore

 Profile Answers by mallakishore Questions by mallakishore

• Oct 20th, 2005

These Parameters are used to provide Administrative access and change run time values of the job.EDIT>JOBPARAMETERSIn that Parameters Tab we can define the name,prompt,type,value

Answer Question  Select Best Answer

satish kumar

• Apr 16th, 2006

hicontainers r speacial type of jobs in the datastage that will simplify the job design either in the server or parallel jobs.2 types of containers1.Local containers2 shared containers   Loc...

mallakishore

 Profile Answers by mallakishore Questions by mallakishore

• Oct 20th, 2005

There are Two types of containers1.Local Container2.Shared ContainerLocal container is available for that particular Job only.Where as Shared Containers can be used any where in the project.Local cont...

Answer Question  Select Best Answer

qwert123

 Profile Answers by qwert123 Questions by qwert123

• Jun 30th, 2009

Automation of loading is supported partly in Informatica so third party tools are needed to achieve this, while data stage supports automation of loading fully.

Jimmy

• Sep 11th, 2005

Here is a very good articles on these differences... whic hhelps to get an idea.. basically it's depends on what you are tring to accomplishwhat are the requirements for your ETL tool? Do you have lar...

Answer Question  Select Best Answer

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 10th, 2007

There is a lock for update option in Hashed File Stage, which locks the hashed file for updating when the search key in the lookup is not found.

Sharanu Patil

• Feb 28th, 2006

Question is not clear still, i think 'insert to update' is updated value is inserted to maintain  history

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

srilaja

 Profile Answers by srilaja Questions by srilaja

• May 19th, 2010

About DataStage Product- DataStage was conceived at company called VMark that developed two notable products: UniVerse database and the DataStage ETL tool in first half of 1996.- VMark acquired UniDat...

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

Please do fish for such kind of info from the net.

Answer Question  Select Best Answer

madan

• Apr 29th, 2006

Merge stage in used for only Flat files in server edition

Sharanu Patil

• Feb 28th, 2006

I think above answer is more then enough

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

• May 22nd, 2006

This means try to improve the performance by avoiding use of constraints wherever possible and instead using them while selecting the data itself using a where clause. This improves performace.

Sharanu Patil

• Feb 28th, 2006

Constraints is nothing but restrictions to data.here it is restriction to data at entry itself , as he told it will avoid unnecessary data entry .

Answer Question  Select Best Answer

tannya

• Nov 8th, 2006

The third point specifies about tuning the performance of job,use the power of DBMS means one can improve the performance of the job by using teh power of Database like Analyzing,creating index,creating partitions one can improve the performance of sqls used in the jobs.

Sharanu Patil

• Feb 28th, 2006

Question is not clear eventhough i wil try to answer somethingIf u have SMP machines u can use IPC,link-colector,link-partitioner for performance tuningIf u have cluster,MPP machines u can use parallel jobs

Answer Question  Select Best Answer

qwert123

 Profile Answers by qwert123 Questions by qwert123

• Jul 1st, 2009

Hi, I worked on a process which was loading target table after performing email standardization on source files.I performed the following validations:1)all letters should be in smallcase2)email id fie...

sivarao

 Profile Answers by sivarao Questions by sivarao

• Dec 28th, 2005

Check for Parameters.and check for inputfiles are existed or not and also check for input tables existed or not and also usernames,datasource names,passwords like that

Answer Question  Select Best Answer

bmdirshad

 Profile Answers by bmdirshad Questions by bmdirshad

• May 19th, 2008

when u open sequential file to editin general tab u have the an check box option - stage uses filter command selec this.and then go for required page(inputs/outputs)you will find in page's Ge...

Sreedhar

• Jan 30th, 2006

We have some thing called as after job subroutine and Before subroutine, with then we can execute the Unix commands. Here we can use the sort sommand or the filter cdommand

Answer Question  Select Best Answer

Radhika

• Jun 27th, 2006

Hi,I am using DataStage 7.5, Unix.  we can use shared container more than one time in the job.There is any limit to use it. why because in my job i used the Shared container at 6 flows. At any time only 2 flows are working. can you please share the info on this.Thanks,Radhika

Sharanu Patil

• Feb 28th, 2006

Sure ,u can use no doubt abt that

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

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 25th, 2009

In UNIX,three files need to be configured.a) uvodbc.configb) odbc.inic) dsenva)uvodbc.config : Here you need to specify the name of data spurce(DSN).Existing configurations in the file can be referred...

ram

• Sep 14th, 2007

You should create DSN in Unix box where datastage server is installed.? Creating at client machine would not be of any use..You need to have database client software installed on the datastage server (Unix box).

Answer Question  Select Best Answer

kanth

• Nov 15th, 2006

Meta stage contians data about the data it contains the description of data and location of the data

Kevin

• Feb 10th, 2006

Basically it is Ascential's metadata repository

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 3rd, 2006

yes you can change the column name only for oracle 9.2 and above.RDBMS:   Relational DataBase Managment System ( for example a combination of object type into  nested table and  us...

SunilDutt N

• Apr 19th, 2006

Yes we can alter Column name in a table using the following query:alter table rename column to RegardsSunilDutt N

Answer Question  Select Best Answer

ramoojobs

 Profile Answers by ramoojobs Questions by ramoojobs

• Apr 21st, 2006

Complex file and Surrogate key generator stages are added in Ver 7.5    

srinivas

• Apr 14th, 2006

As of my knowledge the main enhancement i found is we can generate reports in 7.5 where u can't in 7.0and also we can import more plug-in stages in7.5

Answer Question  Select Best Answer