-
What is panthom error in data stage
the_xxx
- Mar 19th, 2007
For every job in DataStage, a phantom is generated for the job as well as for every active stage which contributes to the job. These phantoms writes logs reg the stage/job. If there is any abnormality...
ATTILI
- Mar 19th, 2007
For every job in DataStage, a phantom is generated for the job as well as for every active stage which contributes to the job. These phantoms writes logs reg the stage/job. If there is any abnormality...
-
How find duplicate records using transformer stage in server edition
the_xxx
- Mar 20th, 2007
Transformer stage to identify and remove duplicates from one output, and direct all input rows to another output (the "rejects"). This approach requires sorted input.
the_xxx
- Mar 20th, 2007
This is questions has got more answers as the elimination od duplicates are situation specific. Depending upon the siutation we can use the best choice to remove duplicates.1. Can write a SQL qurey de...
-
What is an environment variable??
the_xxx
- Mar 21st, 2007
Here is the full FAQ on this topic:Creating project specific environment variables- Start up DataStage Administrator.- Choose the project and click the "Properties" button.- On the General tab click t...
yukthi
- Oct 13th, 2006
Thanx
-
How to set Variables in DataStage?
rajenmari
- Mar 26th, 2007
Use Stage variable to set variable in transformation properties.where you set user definied variable.reddy
-
How to call a Stored procedure which is in SQL Server database in Datastage job? I want to pass job parameters as one of the SP parameters and for remaining SP parameters , I want to use default values. Also I want to perform transformation on the result set of SP.
rajenmari
- Mar 26th, 2007
In ODBC propertiesClick on OUTPUT General select Stored Procedurebrowse to get the stored procedure if have not import then you need to import it.try this if still have problem buzz me.Raj Reddy
-
Difference between transform and routines?
rajenmari
- Mar 26th, 2007
Routine : Routine is like procedure which is called to process certain operation.GoSub ADD(A,B)ADD(A,B):C=A+Breturn C
shiva
- Jun 29th, 2006
HiTransformers are used to transform the data from one from to other form where as routines are used to implement the business logic
-
How to eleminate the errors in delimited flat file?
-
-
-
Is it possible to calculate a hash total for an EBCDIC file and have the hash total stored as EBCDIC using Datastage?
Currently, the total is converted to ASCII, even tho the individual records are stored as EBCDIC.
-
-
Do you know about INTEGRITY/QUALITY stage?
suganyasug
- Apr 18th, 2007
Qulaity Stage can be integrated with DataStage, In Quality Stage we have many stages like investigate, match, survivorship like that so that we can do the Quality related works and we can integrate with datastage we need Quality stage plugin to achieve the task.
sekr
- Jun 8th, 2006
could you please expalin in detail what excatly quality stagestage,auditstage,profilestage used in datastage and where it is used in datastage .thanks in adv.
-
-
-
Differentiate Database data and Data warehouse data?
Data in a Database is a) Detailed or Transactional b) Both Readable and Writable. c) Current.
-
Differentiate Primary Key and Partition Key?
Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition like Hash, DB2, Random etc..While using Hash partition we specify the Partition Key.
hanug
- May 7th, 2007
Hi:Primary key is the key we define on the table column or set of columns(composite pk) to make sure all the rows in a table are unique.Partition key is the key that we use while partition the table(i...
-
How do you pass filename as the parameter for a job?
hanug
- May 7th, 2007
1. Define the job parameter at the job level or Project level.2. Use the file name in the stage(source or target or lookup)3. supply the file name at the run time.Hanu.
sridhar245
- Nov 28th, 2005
1. Go to DataStage Administrator->Projects->Properties->Environment->UserDefined. Here you can see a grid, where you can enter your parameter name and the corresponding the path of the fil...
-
How do you do oracle 4 way inner join if there are 4 oracle input files?
hanug
- May 7th, 2007
The Question asked incorrectly.there wont be any Oracle file. It is Oracle table or view object.I never heard about Oracle input file.Can you please explain what your actual question is?Hanu.
-
What is DS Administrator used for - did u use it?
hanug
- May 7th, 2007
It is primarily used to create the Datastage project, assign the user roles to the project, set parameters of the jobs at project level. Assign the users to the project can also be done here.Hanu.
CNU
- Aug 2nd, 2005
The Administrator enables you to set up DataStage users, control the purging of the Repository, and, if National Language Support (NLS) is enabled, install and manage maps and locales.
-
Types of Parallel Processing?
Parallel Processing is broadly classified into 2 types. a) SMP - Symmetrical Multi Processing. b) MPP - Massive Parallel Processing.
DataStage Interview Questions
Ans