11
11
11
Server Components:
Data Stage Engine
Meta Data Repository
Package Installer
DSHostName
DSProjectName
DSJobStatus
DSJobName
DSJobController
DSJobStartDate
DSJobStartTime
DSJobStartTimestamp
DSJobWaveNo
DSJobInvocations
DSJobInvocationId
DSStageName
DSStageLastErr
DSStageType
DSStageInRowNum
DSStageVarList
DSLinkRowCount
DSLinkLastErr
DSLinkName
Q 27 What is Routines?
Routines are stored in the Routines branch of the Data Stage Repository, where you can
create, view or edit. The following programming components are classified as routines:
Transform functions, Before/After subroutines, Custom UniVerse functions, ActiveX
(OLE) functions, Web Service routines
What are the command line functions that import and export the DS jobs?
Answer:
dsimport.exe - imports the DataStage components.
dsexport.exe - exports the DataStage components.
Did you Parameterize the job or hard-coded the values in the jobs?
Answer:
Always parameterized the job. Either the values are coming from Job Properties or from
a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some
parameters in your jobs. The often Parameterized variables in a job are: DB DSN name,
username, password, dates W.R.T for the data to be looked against at.
What are Routines and where/how are they written and have you written any
routines before?
Answer:
Routines are stored in the Routines branch of the DataStage Repository, where you can
create, view or edit.
The following are different types of Routines:
1. Transform Functions
2. Before-After Job subroutines
3. Job Control Routines
What will you in a situation where somebody wants to send you a file and use that
file as an input or reference and then run job.
Answer:
• 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.
Under UNIX: Poll for the file. Once the file has start the job or sequencer depending on
the file
What is the utility you use to schedule the jobs on a UNIX server other than using
Ascential Director?
Answer:
Use crontab utility along with dsexecute() function along with proper parameters passed.
How do you rename all of the jobs to support your new File-naming conventions?
Answer:
Create an Excel spreadsheet with new and old names. Export the whole project as a dsx.
Write a Perl program, which can do a simple rename of the strings looking up the Excel
file. Then import the new dsx file probably into a new project for testing. Recompile all
jobs. Be cautious that the name of the jobs has also been changed in your job control jobs
or Sequencer jobs. So you have to make the necessary changes to these Sequencers.
Question: Suppose that 4 job control by the sequencer like (job 1, job 2, job 3, job
4 ) if job 1 have 10,000 row ,after run the job only 5000 data has been loaded in
target table remaining are not loaded and your job going to be aborted then.. How
can short out the problem?
Answer:
Suppose job sequencer synchronies or control 4 job but job 1 have problem, in this
condition should go director and check it what type of problem showing either data type
problem, warning massage, job fail or job aborted, If job fail means data type problem or
missing column action .So u should go Run window ->Click-> Tracing->Performance or
In your target table ->general -> action-> select this option here two option
(i) On Fail -- Commit , Continue
(ii) On Skip -- Commit, Continue.
First u check how much data already load after then select on skip option then
continue and what remaining position data not loaded then select On Fail ,
Continue ...... Again Run the job defiantly u gets successful massage
What is the difference between the Filter stage and the Switch stage?
Ans: There are two main differences, and probably some minor ones as well. The two
main differences are as follows.
1) The Filter stage can send one input row to more than one output link. The
Switch stage can not - the C switch construct has an implicit break in every case.
The Switch stage is limited to 128 output links; the Filter stage can have a theoretically
unlimited number of output links. (Note: this is not a challenge!)
Advantages of the DataStage?
Answer:
Business advantages:
Technological advantages:
Data stage manager is used for to import & export the project to view & edit the
contents of the repository.
Data stage administrator is used for creating the project, deleting the project & setting
the environment variables.
Data stage director is use for to run the jobs, validate the jobs, scheduling the jobs.
Server components
DS server: runs executable server jobs, under the control of the DS director, that extract,
transform, and load data into a DWH.
DS Package installer: A user interface used to install packaged DS jobs and plug-in;
Repository or project: a central store that contains all the information required to build
DWH or data mart.
I have some jobs every month automatically delete the log details what r the steps u
have to take for that
I want to run the multiple jobs in the single job. How can u handle.
VSS is designed by Microsoft but the disadvantage is only one user can access at a time,
other user can wait until the first user complete the operation.
CVSS, by using this many users can access concurrently. When compared to VSS, CVSS
cost is high.
What is the difference between clear log file and clear status file?
Clear log--- we can clear the log details by using the DS Director. Under job menu
clear log option is available. By using this option we can clear the log details of
particular job.
Clear status file---- lets the user remove the status of the record associated with all
stages of selected jobs.(in DS Director)
I developed 1 job with 50 stages, at the run time one stage is missed how can u
identify which stage is missing?
By using usage analysis tool, which is available in DS manager, we can find out the what
r the items r used in job.
Pivot stage is used to transposition purpose. Pivot is an active stage that maps sets of
columns in an input table to a single column in an output table.
If a job locked by some user, how can you unlock the particular job in DS?
We can unlock the job by using clean up resources option which is available in DS
Director. Other wise we can find PID (process id) and kill the process in UNIX server.
I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value?
X value is Zero.
Iconv Function Converts a string to an internal storage format.It takes 31 dec 1967 as
zero and counts days from that date(31-dec-1967).
I have three jobs A,B,C . Which are dependent on each other? I want to run A & C
jobs daily and B job runs only on Sunday. How can u do it?
First you have to schedule A & C jobs Monday to Saturday in one sequence.
Next take three jobs according to dependency in one more sequence and schedule that job
only Sunday.
Because the Transformer stage is an active stage type, you can specify routines to be
executed before or after the stage has processed the data. For example, you might use a
before-stage routine to prepare the data before processing starts. You might use an after-
stage routine to send an electronic message when the stage has finished.
Date Conversions
The following examples show the effect of various D (Date) conversion codes.
Date Conversions
The following examples show the effect of various D (Date) conversion codes.