-
How to count the records except header and footer in a sequential file
I have a sequential file it is having some records and the same file is having header and footer now my question is how to count the records in a file which is not counts the header and footer records and then transform the records in to target and then again we fetch the header and footer to that file which records are matched with the header
-
Compile Source Records
I have 10 Million records in source and target 5 million records were populated then job was aborted again i go and compile and run the job when that time job will run from 5million 1 record to remain records how?
-
Differentiate Database data and Data warehouse data?
Data in a Database is a) Detailed or Transactional b) Both Readable and Writable. c) Current.
-
What is Modulus and Splitting in Dynamic Hashed File?
In a Hashed File, the size of the file keeps changing randomly. If the size of the file increases it is called as "Modulus". If the size of the file decreases it is called as "Splitting".
Santhosh_DataStage
- Dec 2nd, 2009
Modulo is the calculated value which is calculated by using a Hash File Calculator. It tells the optimal number of groups to be created in the hash file to use it effectively. The Input to this Modulo calculation are the approximate number of records and the width of each record.
Milestones
- Sep 22nd, 2005
The modulus size can be increased by contacting your Unix Admin.
-
How do you pass the parameter to the job sequence if the job is running at night?
gagan8877
- May 8th, 2007
You can insert the parameter values in a table and read them when the package runs using ODBC Stage or Plug-In stage and use DS variables to assign them in the data pipeline, or pass the par...
malneedi
- Sep 29th, 2005
Two ways1. Ste the default values of Parameters in the Job Sequencer and map these parameters to job.2. Run the job in the sequencer using dsjobs utility where we can specify the values to be taken for each parameter.
-
How many jobs have you created in your last project?">
How many jobs have you created in your last project?
100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody
Prakash3366
- Jun 17th, 2009
Depends on which type of project you are working. Sometimes in Parallel Jobs we will take more time to finish complex job. If you have 3 years experience then you have to tell more than 100 Jobs, Few jobs in server and few in parallel
Anjan Roy
- Sep 16th, 2005
- I don't think these are the right numbers. Someone creating 100+ jobs in 6 months !! If you do the math - it would be 6 Months = 6 months * 22 Days * 8 Hours = 1056 hours. The above state...
-
What is DS Manager used for - did u use it?
prashanth
- Aug 25th, 2005
Datastage maneger is used to export and import purpose [/B] main use of export and import is sharing the jobs and projects one project to other project.
-
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.
-
What other ETL's you have worked with?
Informatica and also DataJunction if it is present in your Resume.
mahesh4346
- Feb 29th, 2008
ETL tools are1) Informatica by Informatica Corporation2) Datastage by IBM3) Ab initio by Ab initio software Corporation4) Data Junction by Pervasive software 5) Oracle Warehouse Builder by Oracle Corp...
-
How good are you with your PL/SQL?
On the scale of 1-10 say 8.5-9
padmanabhan.s
- Jul 29th, 2008
Though we dont write the PL/SQL directly, we can write a procedure or a fucntion which determines our needs and then can be called in the datastage ODBC or OCI stage using call() statement. For eg. if...
-
-
What are the Job parameters?
lakshmib
- Sep 24th, 2008
It is a runtime parameter which allows you to enter the value to restrict the data at the job run time. A job parameter is created with name,promt,data type,default value,and it is reprsented as follows #parameter name#.
mallakishore
- Oct 20th, 2005
These Parameters are used to provide Administrative access and change run time values of the job.EDIT>JOBPARAMETERSIn that Parameters Tab we can define the name,prompt,type,value
-
How can we create Containers?
satish kumar
- Apr 16th, 2006
hicontainers r speacial type of jobs in the datastage that will simplify the job design either in the server or parallel jobs.2 types of containers1.Local containers2 shared containers Loc...
mallakishore
- Oct 20th, 2005
There are Two types of containers1.Local Container2.Shared ContainerLocal container is available for that particular Job only.Where as Shared Containers can be used any where in the project.Local cont...
-
What is difference between data stage and informatica
qwert123
- Jun 30th, 2009
Automation of loading is supported partly in Informatica so third party tools are needed to achieve this, while data stage supports automation of loading fully.
Jimmy
- Sep 11th, 2005
Here is a very good articles on these differences... whic hhelps to get an idea.. basically it's depends on what you are tring to accomplishwhat are the requirements for your ETL tool? Do you have lar...
-
What is ' insert for update ' in datastage
gagan8877
- May 10th, 2007
There is a lock for update option in Hashed File Stage, which locks the hashed file for updating when the search key in the lookup is not found.
Sharanu Patil
- Feb 28th, 2006
Question is not clear still, i think 'insert to update' is updated value is inserted to maintain history
-
-
Please list out the versions of datastage Parallel , server editions and in which year they are realised.
srilaja
- May 19th, 2010
About DataStage Product- DataStage was conceived at company called VMark that developed two notable products: UniVerse database and the DataStage ETL tool in first half of 1996.- VMark acquired UniDat...
-
-
-
DataStage Interview Questions
Ans