Something about DataStage, DataStage Administration, Job Designing,Developing, DataStage troubleshooting, DataStage Installation & Configuration, ETL, DataWareHousing, DB2, Teradata, Oracle and Scripting.
Showing posts with label DSparam. Show all posts
Showing posts with label DSparam. Show all posts
Monday, June 23, 2014
Purpose of Parameters in ETL
In an ETL process, a parameter represents an attribute that is not hard coded or sourced from the transactional system. Parameters provide flexibility so that you can adapt ETL processes to fit your business requirements.
or in Simple Words, A job parameter is a way to change a property within a job without having to alter and recompile it. These are input values to job/process which can be changed time to time as per need.
Thursday, September 26, 2013
Interview Questions : DataStage - Part 2
For more : Visit HERE
What is the importance of Surrogate
Key in Data warehousing?
Ans : Surrogate Key is a Primary Key for a Dimension table. Most
importance of using it is independent of underlying database. i.e Surrogate Key
is not affected by the changes going on with a database
What does a Config File in parallel
extender consist of?
Ans: Config file consists of the following.
a) Number of Processes or Nodes.
b) Actual Disk Storage Location.
a) Number of Processes or Nodes.
b) Actual Disk Storage Location.
Thursday, September 19, 2013
DataStage compile error 65280; Couldn't change directory to /tmp
Error when trying to compile parallel (PX) jobs in a project.
The compilation errors include the following:
Subprocess command failed with exit status 65280.
Output from subprocess: Couldn't change directory to /tmp : No such file or directory
Wednesday, February 20, 2013
Changing Logs method in DataStage
DataStage logging was changed at release 8.1 to log job run detail records into the operational repository, (xmeta) rather than the local project level log files, (RT_LOGxxx).
In case XMETA repository logging causing problem (i.e not visible from designer), we able to change the logging method back to local project log files.
Monday, June 25, 2012
Subscribe to:
Posts
(
Atom
)