-
How do you create a sequencer in datastage parallel extender
nikhilanshuman
- Mar 22nd, 2010
First thing,it is "sequence".Sequencer is an activity in the Datastage sequence.Steps to Create a sequence:a) Go To Menu.In the Menu,select File->New.b) In the window that appears,select ...
-
How and where do we use or integrate Java with Datastage?
nikhilanshuman
- Mar 22nd, 2010
Java can be integrated into Datastage using JavaPack.There are two stages which are come in javapack :a) JavaClient : It is used for Sources or targets.b) Java Transformer :It is used for processing row by row. Both stages allow to use the Java Classes in your datastage jobs.
-
Host name specified is not valid, or the host is not responding
I downloaded data stage at my home pc. when iam trying to open data stage administrator datastage designer or datastage director it showing me an error like "host name specified is not valid, or the host is not responding(81011). could any body can help me out how can i get host name, user name and password, because i didn't mention any host name, username or password while installing the software.
nikhilanshuman
- Nov 30th, 2010
In the server name, specify "127.0.0.1". This is the address of your machine. When the user id and password is asked, there is a checkbox to Omit the userid and password. Mark that checkbox. After ...
-
A batch is running and it is scheduled to run in 5 minutes. But after 10 days the time changes to 10 minutes. What type of error is this and how to fix it?
nikhilanshuman
- Dec 18th, 2010
If the batch is taking more time to execute(10 mins),it may be due to the performance issues.In such cases the performance optimizstion mesures should be taken.If without making any changes,time taken...
-
What is Invocation ID?
prasoon.pandey
- Sep 18th, 2007
This only appears if the job identified by Job Name has Allow Multiple Instance enabled. Enter a name for the invocation or a job parameter allowing the instance name to be supplied at run timeAn '...
-
What are the errors you expereiced with data stage
manoharkolukula
- Jan 25th, 2008
Here in datastage there are some warnings and some fatal errors will come in the log file. If there is any fatal error means the job got aborted but if there are any warnings are there mean...
-
Where does director create its log files?
We are spacing a problem of C: getting filled up because of a creation of some file. I think it is because of the director log files.
nikhilanshuman
- Dec 25th, 2009
The log files are stored at server.At the client side(windows) the log files are not stored.The logs are maintained in RT_Logn files on datastage server.Deleting logs:You can set Auto purge of job logs from datastage administrator to delete the log files automatically.
-
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....
-
Explain about job control language such as (DS_JOBS)
wahi80
- Feb 19th, 2008
Used to run jobs from the command line, we can all use dsjobs to get log info about the job.
-
How to use database performance tuning and also ds job performance in datastage.
nikhilanshuman
- Nov 30th, 2010
Database performance tunings:Whenever you are firing queries on source databases containing joins, make sure that proper indexes are created for optimizing query performance.Try to partition the tab...
-
Datastage Nodes and CPUs
Please Give Me some small Notes on Nodes and CPUs. I have one question when i am using 4 nodes and 5 CPUS how many Processors will be going to execute. Please help me in this...
nikhilanshuman
- Mar 19th, 2010
Assignment of nodes and processes to CPUs is totally dependent on the Operating System. It depends on many criterias like how the processes are scheduled to be run.Which processor has free cycles avai...
-
Parameter file usage in Datastage
Can anyone tel me how to use a file to fetch the parameter values for a parallel job in datastage as i don't want it to be hard coded.The format for the file shall be (name,value) pair. please help me...Thanks,Deepa
Abhijain
- Oct 3rd, 2008
In Datastage sequence, there is a stage named "UserVariable_Activity", this can use to fetch the parameter. Create a new user variable in the uservariable_activity stage and for the expression part of it, you can simply give your parameter file path.
-
Performance in sort stage
i am running huge amount of data through a sort stage and it is very slow. Is there any option which can increase the performance with in the sort stage?
manoharkolukula
- Jan 25th, 2008
See if it is orcle db then u can write user def query for sort and remove duplicates in the source itself. and maintaining some key partition teqniques u can improve the performence. If it is not the ...
-
Memory allocation while using lookup stage
Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be allocated for both type of lookups?
harishsj
- Jan 22nd, 2008
"Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be ...
-
Even and Odd Number Nodes
To run Job why do we use only even number nodes like 2,4,6,8.., Why don't we use 1,3,5..,?
anshulsri2
- Jan 23rd, 2008
There are no odd number nodes used in datastage, for the simple reason we are not allowed to configure odd number nodes on the datastage server.
-
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...
-
What is datastage DSTX
sinhasaurabh014
- Apr 9th, 2008
DataStage Transformation Extender was developed,owned and marketed my Meractor(an aviation company). e.g. Version 6.5.2 is Mercator. Later on Ascential Softwares purchased it and named it as DataStage...
-
How do you implement SCD in Datastage
How we will implement scd in DS?Explain with example ?Any scd ie scd1,scd2,scd3 .
wahi80
- Feb 19th, 2008
If you are using Server version, you will have to use a combination of transformer, hashfiles for lookup and stage variables. If you are using the parallel version you will have touse the Change Capture and Change Apply stages
-
How can we load the flat file
How can i load a flat file into target as fast as i can?Assuming that the source bottleneck is not there,that is there is no performance issues in the source side.
nikhilanshuman
- Dec 18th, 2010
A Flat file can be read using sequential file stage.To make data load faster,try implementing least stages in you job and use minimal transformations.if you are trying to load the data of a flat file ...
-
When we have to contact with admin people...
Have you ever contact with the DS Administration people?What are the situations and what problems you phased?
DataStage Interview Questions
Ans