-
-
Datastage jobs
if job compiled with "job completed successfully". but The DS director window of Log page shows warning messages.what will we do?giv answer.
veer.dwh
- Sep 19th, 2009
Data Stage job can finish successfully with n no of wrnings in DS. if suppose some records are rejected which are coming from source also DS director give warning message but those records are not mee...
-
How to eleminate duplicate rows in data stage?
natashajain21
- Sep 22nd, 2009
Some of the methods to remove duplicates -> 1. Remove Duplicate Stages2. Hash File3. In Sort stage there are 3 ways -> a. Set CHANGECAPTURE Property to True . you ha...
ravi
- Dec 11th, 2006
There are two methods for eleminating duplicate rows in datastage1. Using hash file stage (Specify the keys and check the unique checkbox, Unique Key is not allowed duplicate values)2. Using Sort stage by link remove duplicate stageThanx
-
Import Data with More than One Delimiter
DataStage can accept more than one delimiter. How to import data if it contains more than one delimiter?
veer.dwh
- Sep 23rd, 2009
DS supports more than one delimiter, if file has more then one delimiter. to read multiple delimeters from flat file, define flat file type as fixed width.Suppose your flat file has data belowcust_no,...
-
SQL Sever Stored Procedure
How to call a Stored procedure which is in SQL Server database in Datastage job?
veer.dwh
- Sep 23rd, 2009
You can use strored procedure stage in DS to call the any stored procedures from any Database type.Regards,Veeru.
-
What is SEQ file buffer
veer.dwh
- Sep 23rd, 2009
Deyault buffer size foe seq file is 128MB. if you want increse manually, to to Adminstrator tunable tab--> buffer size option there you can specify if you want increase.regards,Veeru.
-
Hashing Algorithm
Explain What is mean by Hashing Algorithm?
veer.dwh
- Sep 23rd, 2009
Hashing alogarithm is used when you create hash files in server jobs. it takes key field and distribute records avilable cpus in DS sercver while running the DS job. the cpu utiliztion in this process may vary based on server configuration.Regards,Veeru.
-
How can we improve the performance of a link collector in the case of handling more than 25000 records?
veer.dwh
- Sep 23rd, 2009
Link partitiner and collecter are used to develop the parallism in server jobs.if source has huge amount of data that situation you can use these stages to perfoem parallism in server job environment....
-
SCD2 Parallel Jobs
How to implement SCD2 in parallel jobs?
veer.dwh
- Sep 23rd, 2009
If you are using DS 8.0.1 version, it is very east to implement SCD2 using SCD stage. it supports 2 input links and 2 output links. from the 2 input links. primary Dataset it takes as a current dates...
-
Feature of DataStage 8.01 Version
What are the main features of DataStage 8.01 Version?
veer.dwh
- Sep 23rd, 2009
There are several new futures includes in DS 8.0.1 compare to 7.5 version.In 8.0.1 IBM included Quality stage, IBM information server (profile stage and audit stage) . these are not available in 7.5...
veer.dwh
- Jul 20th, 2009
Compare to DataStage 7.5 Accential DataStage, with DataStage 8.0 IBM websphere datastage Architecture got changedIn 8.0 IBM included client components of IBM information server which supports profiling stage along with Quality stage features are included in designer client component.
-
What are different types of star schema??
veer.dwh
- Sep 28th, 2009
There are 2 types of star schemas in datastage1.Starschema: A single fact table sits in middele and surounded dimension tables radically connect with fact table like a star. in star schema dimension t...
PRASHANT NARAYANI
- Dec 27th, 2006
Multi star schema or galaxy schema is one of the type of star schema
-
What is a sequential file that has single input link??
veer.dwh
- Sep 28th, 2009
Sequntial file stage supports either one input link or one output link.it runs sequntially(like row by row process), if it is reading single input file and won't support any parallism.it runs parallely, if it is reading multiple files and will support parallism techniques.
Raghu
- Aug 1st, 2007
Sequential file always has?single link because its it cannot accept the multiple links or threads.Data in sequential file always runs sequentially..HTHRaghu Mule
-
How can we improve the job performance?
veer.dwh
- Sep 28th, 2009
There are several performance techniques are avilable to help run the job faster1. Eliminate unwanted data and columns as early as possible in your job design, each unwanred column and data requ...
Bhaskar
- Dec 29th, 2006
We can put hash file in lookup. This will index the input data based on key column (which we define). Thus improve performance. Also Array size can be increased in final table stage.
-
What is the sequencer stage??
veer.dwh
- Sep 28th, 2009
Sequencer stage comes in job sequencer.
Job sequencer uses to run multiple jobs based on dependency.
Sequencer stage activity is one type of activity stage in job sequencer, using this you can run n number of jobs parallely.amardeep.reddy
- Dec 6th, 2006
Lets say there are two jobs (J1 & J2) as the input links and one job (J3) as output link for a sequencer stage in a DS job sequencer. The sequencer can be set to "ALL" or "ANY". If it is set to "A...
-
XML File
How to read an XML File?
vujjini1974
- Sep 29th, 2009
Use a XML Folder stage to read the XML file and pass the content to XML Input stage to parse out tabular records.
-
How many types of look up stages in datastage parallel ext?
vujjini1974
- Sep 30th, 2009
There is only one look up stage in parallel extender, and it is of two types one is normal look up and another one is Sparse look up,mostly we normal look up for the reference datasets.
-
Purpose of using the key and difference between Surrogate keys and natural key
-
How I can convert Server Jobs into Parallel Jobs?
veer.dwh
- Oct 1st, 2009
Hi,I have worked on server to px migration project. you can't directly convert a server job to PX job. the only way is, you have to redevelop the px job using px environment.Regards,Veeru.
Abhijain
- Feb 20th, 2008
On a job level- to convert server jobs into a parellel job is not possible.The mechnism of server jobs is different then that of parellel jobs.You have to re-build the job.
-
How the job status changed when the datasets it process is locked by another job
When the data processed by job1 is locked by job2 with higher priority, what will happen about the status of job1, changing from running to aborted , or still running. does it have any relationship with the database
vujjini1974
- Sep 30th, 2009
If its reference dataset and you are doing Lookup then job will run but no records will come from that Dataset, so you should rerun the dataset job and then run the other job to get the records.
-
What is the difference betwen Merge Stage and Lookup Stage?
veer.dwh
- Oct 7th, 2009
Both stages use for joining the data. using merger you can capture rejected data from N no of update datasets but you can't capture master source data. but using lookup you can capture 1 reject data set from source only not from the refrence datasets.Regards,Veeru.
srinivasguptha
- Jan 29th, 2007
Lookup stage:1. Used to perform lookups.2. Multiple reference links, single input link, single output link, single rejects link, single primary link. 3. Large amount of memory usage. Because paging re...
DataStage Interview Questions
Ans