-
-
-
-
How to enable the runtime column propagation in the datastage?Where does this option exists?
nagoosk
- May 29th, 2008
It is available in 3 places1)When u open the ds Administrator ; there open any project properties;there u can see the Runtime Column Propagation.2) If u open the job properties there u can see th...
sarita
- Dec 11th, 2006
There is an option in data stage administrator->projects tab->properties button->general tab-> enable runtime column propogation for parallel jobs. If you enable this, you can select runti...
-
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
-
-
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
-
sample:
Cola Colb Colc
1 10 100
2 20 200
3 30 300
Assume: cola is primary key
How will you fetch the record with maximum cola value using data stage tool into the target system">Suppose you have table "sample" & three columns in that tablesample:Cola Colb Colc1 10 1002 20 2003 30 300Assume: cola is primary keyHow will you fetch the record with maximum cola value using data stage tool into the target system
-
How to run a job using Command line?
nikhilanshuman
- Dec 25th, 2009
The command is "dsjob" and case sensitive.Following is the command :dsjob -run -wait -warn 999 -jobstatus -project name -job name
sai
- Mar 31st, 2007
Dsjobs-run-jobstatus projectname jobname/filename
-
-
If i run the job first 10 times there is no time variation in job execution.In same way i run the job for 100 times it takes 10 times extra time.what is the solution for it?
nikhilanshuman
- Mar 19th, 2010
The solution is to check for any bottlenecks. Try running the job for two or three more times after certain intervals and take performance statistics. If the performace is still slow then try optimizing the jobs.
nikhilanshuman
- Mar 19th, 2010
Depends on the runtime environment. Sometimes on the datastage server many processes are running at the same time. Sometimes the server might be lacking enough resources required for the job. Th...
-
-
What is the use and advantage of procedure in datastage?
hemant.agarwal03
- Nov 13th, 2009
If we have a complex business logic and we may need to create mutiple jobs to achive that , then we use procedure in data stage which provide us final output in a single job. It is faster then normal SQL statement also.
Him121
- Jun 22nd, 2007
To trigger Database operations at before or after DB stage access.
-
How do we use Job Parameters in datastage jobs.
I know we use them in the project level and also in the job level and also that we can give values at run time(like UN, Pswd etc). Theoratically I understood. But practically unable to implement it. Can somebody explain me in detail with an example. I wud seriously appreciate your help. Thanks Guyz.
Behrouz
- Jan 27th, 2009
For example I create a parameter for my hashfile folder like it : Name: $pHashdir, type:string,def.value: C:DataStageInput DATAHash and when I use my hash file in path file name i use just ...
Fanguna
- Nov 19th, 2007
There is an icon to go to Job parameters in the tool bar. Or you can press Ctrl+J to enter into Job Parameters dialog box. Once you enter, give a parameter name and corresponding default value for it....
-
What is surrogate key? what is routine and explain the use in datastage parallel server jobs?
nikhilanshuman
- Nov 30th, 2010
A surrogate key is none business key. it can be a sequential number with no business meanings. these are useful for the underlying applications to maintain relationships between tables.Routines are th...
pavan.daddanalla
- Apr 14th, 2008
Surrogate key is a separate key column which is generated by surrogate key generator. routines are nothing but subset of functions
-
Explain the best approch to do a SCD type2 mapping in parallel job?
manoharkolukula
- Feb 12th, 2008
use CDC, lookup, trasformer stages to impliment SCD2. In CDC just give the changed values and key column, then capture the changed records, in transformer just give the constraint for 0,1,2,3(del,insert,copy,updated data), u will get inserted data and updated data, copied data, deleted data.
-
Problems with Datastage - Date format & Null Handling of a Date field in a schema file
Hi,I have a .csv file as my source.I am reading the data using asequential file stage.Then I am validating the format of the data using a schema file.The date format of the incoming file is '%dd/%mm/%yyyy'.So the datecolumn has a fixed length 10.Now according to the provided incoming data set the date column shouldbe nullable.Can anybody please provide an idea how to handle a nullable datecolumn using...
Abhijain
- Oct 19th, 2009
Read the date field column as varchar and use transformer to check nullabiltiy and if null found assign some default value say '12-Dec-9999' and use the appropriate conversion function an...
Abhijain
- Oct 19th, 2009
Read date field from sequential file as varchar datatype with nullable yes. Use modify stage or transformer to convert the datatype and also check the nullability of the incoming data and if null foun...
-
What is Pipeline Parallelism?
What is Pipeline Parallelism in Datastage?
leelasankar.pr
- Jul 22nd, 2008
It is the ability of a down streem stage to process arow ,which the up streem stage processed that row
-
Check for Job Errors in datastage
in datastage job successfully finished. but showing errors in director window. How do we fix and find the cause for the errors
manoharkolukula
- Feb 12th, 2008
I think in designer u find the green colour but in Director -> log view --> u find some fatal errors and job is aborted, is it, Means job is successfully completed but the data is not loaded in ...
-
What is the use of clear status file
What is the use of clear status file in DS?How we will use it?explain with examples?
nikhilanshuman
- Dec 30th, 2009
If status is cleared for a datastage job,all of its instaces will be deleted.I mean if there is a instance say jobname.inst1 or jobname.inst2 these will be deleted.The entries for that particular jobs will be cleared from RT_Status(n) table.Here n is the job number.
ketanshah123
- Feb 19th, 2008
When you clear a job’s status file you reset the status records associated with all stages in that job. You should therefore use this option with great care, and only when you believe a job has ...
DataStage Interview Questions
Ans