laxman

• Oct 24th, 2006

First of all thanks to srilaxmi for your skill in pivot stage.Pivot stage supports only horizontal pivoting ? columns into rowsPivot stage doesn?t supports vertical pivoting ? rows into columnsExample...

srilakshmi

• Oct 3rd, 2006

 Pivot stage is used to make the horizontal rows into vertical and viceversa

Answer Question  Select Best Answer

Typically a Reject-link is defined and the rejected data is loaded back into data warehouse. So Reject link has to be defined every Output link you wish to collect rejected data. Rejected data is typically bad data like duplicates of Primary keys or null-rows where data is expected. 

sunilsavalasang

• Oct 18th, 2006

we can handle rejected data by collecting them seperately in sequential file......

Answer Question  Select Best Answer

sunil

• Oct 18th, 2006

ETL-> transformation takes place in staging area and in ELT-> transormation takes at either source side r target side............

jpg1dmg

 Profile Answers by jpg1dmg Questions by jpg1dmg

• Sep 26th, 2006

ETL usually scrubs the data then loads into the Datamart or Data Warehouse where as ELT Loads the data then use the RDMBS to scrub and reload into the Datamart or DatawarehouseETL = Extract >>> Transform >>> LoadELT = Extract >>> Load >>> Transform

Answer Question  Select Best Answer

siva

• Oct 16th, 2006

When designing jobs that use plug ins (like Oracle) the parallel engine will use its interpretation of the Oracle meta data (e.g, exact data types) based on interrogation of Oracle, overriding wh...

okey

• Oct 2nd, 2006

The Import Orchestrate Schema wizard allows you to import meta data into DataStage from an Orchestrate schema file, from a file set, or from a data set while ODBC allow you to import metadata in the native format of the database schema.

Answer Question  Select Best Answer

ashok

• Oct 12th, 2006

Hi This mostely will comes under Administrator part.As a Designer only we can add directly byDesigner-view-jobprops-parameters-addenvironment variable-under userdefined-then add.

Ram

• Oct 11th, 2006

We can create environment variables by using DataStage Administrator.

Answer Question  Select Best Answer

yukthi

• Oct 12th, 2006

Thanxs...

Ram

• Oct 11th, 2006

Static hash file don't chane their number of groups(modulas) except through manual resizingDynamic hash file automatically change their no of groups(modulas)in response to the amount of data stored ina file.

Answer Question  Select Best Answer

yukthi

• Oct 12th, 2006

Thanxs...

Babu

• Oct 11th, 2006

Testing of jobs can be performed at many different levels: Unit testing, SIT and UAT phases.Testing basically involves functionality and performance tests.Firstly data for the job needs to be cre...

Answer Question  Select Best Answer

starsaran007

 Profile Answers by starsaran007 Questions by starsaran007

• Sep 30th, 2006

hiThe differerence between reference link and straight link isThe straight link is the one where data are passed to next stage directly and the reference link is the one where it shows that it has a r...

Answer Question  Select Best Answer

A. dsimport.exe- imports the DataStage components.B. dsexport.exe- exports the DataStage components.

Pd

• Sep 22nd, 2006

Parameters: UserName,Password, Hostname, ProjectName,CurrentDirectory(C:/Ascential/DataStage7.5.1/dsexport.exe),FileName(JobName).

domi

• May 18th, 2006

What are the parameters of this command?

Answer Question  Select Best Answer

Dharmendra

• Sep 22nd, 2006

The flat file size depends amount of data contained by that flat file

Answer Question  Select Best Answer

guess

• Sep 21st, 2006

There are three processes start when the DAtastage engine starts:1. DSRPC2. Datastage Engine Resources3. Datastage telnet Services*************************************************

Answer Question  Select Best Answer

Vincent

• Sep 19th, 2006

You can see a list of DataStage Certification links and resources at the Squidoo lens: How do I get Websphere DataStage certification?

Suresh Kumar

• Sep 14th, 2006

Thx Shri for your information.Suresh

Answer Question  Select Best Answer

shri

• Sep 15th, 2006

U can use it with ODBC stage by writing proper SQl quries

Hanu

• Jun 8th, 2006

Don't mix informatica with Datastage.In Datastage, we dont have such kind of stages.

Answer Question  Select Best Answer

rajeev

• Sep 8th, 2006

If your job has more columns which are not defined in metadata if runtime propagation is enabled it will propagate those extra columns to the rest of the jobrajeev

Answer Question  Select Best Answer

Radha

• Sep 7th, 2006

Oracle OCI:       ?         We can write the source query in this stage but we can?t write lookup query in this stage instead of t...

Answer Question  Select Best Answer

rajeevmanukondu

 Profile Answers by rajeevmanukondu Questions by rajeevmanukondu

• Sep 6th, 2006

There is no difference between Ascential Datastage and Datastage ,Now its IBM websphere Datastage earlier it was Ascential Datastage and IBM has bought it and named it as above.Rajeev

Answer Question  Select Best Answer

c2

• Sep 5th, 2006

You can do it at any stage.Just do a hash partion of the input data and check the options Sort and Unique.This will do.

Tasneem

• Aug 11th, 2006

Using a sort stage,set property: ALLOW DUPLICATES :false

Answer Question  Select Best Answer

c2

• Sep 5th, 2006

Use a change Capture Stage.Output it into a Transformer.Write a routine to abort the job which is initiated at the Function.@INROWNUM = 1.So if the data is not matching it is passed in the transformer and the job is aborted.

Answer Question  Select Best Answer