-
How would call an external Java function which are not supported by DataStage?
Starting from DS 6.0 we have the ability to call external Java functions using a Java package from Ascential. In this case we can even use the command line to invoke the Java function and write the return values from the Java program (if any) and use that files as a source in DataStage job.
indianarya
- Apr 11th, 2008
Use the Java PACK. Java Pack has Java Client and Java Transformer Stages. YOu can write your own class and call it from either from Client or Transformer stages.
-
NEED HELP1) I can not get into DataStage Administrator after trying a lot. I give the Host Name or Name of my computer, and I did not give the User Name & Password then I get the error like thisFailed to connect to host: ishaq, project: UV(The host name specified is not valid, or the host is not responding (81011))2)When I give the Host Name User Name & Password then I get the error like this Failed to connect to host: ishaq, project: UV(The host name specified is not valid, or the host is not responding (81011))To solve this problems, I Installed the DataStage 7.5.1, atleast seven times, after this all still I did not get enter into the DataStage Administrator then I format the System, and Re Installed every thing once again from the beginning, then again Installed the DataStage, still I have the same problem, I can not get enter into the DataStage Administrator till now.I am sure, I have Windows XP SP2 Installed on P4 System
sinhasaurabh014
- Apr 9th, 2008
Apart from ensuring that telenet service is running and the option of bypassing,do also make sure that the datastage services(both) are running in services....pretty much the same solution as the firs...
chandrasekarj
- Mar 9th, 2008
There is an option called Bypass......If you select this option.Your problem will be resolved.
-
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...
-
Is it possible to query a hash file? Justify your answer...
jaffar95
- Mar 20th, 2008
Yes you can query a hash file using Datastage Administrator --> Command window -->
John
- Feb 8th, 2007
You can also use a Universe stage if the data is need in your job. I don't recall all details when I used this but I think there is an option when creating the hash file to make it Universe compatable or something like that. Then you can use it in a universe stage and do any query you like on it.
-
How do you eliminate duplicate rows?
-
Job Control and Sequencer
What is the difference between jobcontrol and sequencer?
nagoosk
- Mar 18th, 2008
Jobcontrol: It just inserts the compilation code. Whenever you add the job it just places executable code there. There is no diagrammatical representation here.Sequencer: Sequencer is a diagrammat...
-
What is call hash size more 2GB?This example is exceed 2 Gb yes or no?-rw-rw-r-- 1 s000656 dstage 2154491904 Jul 26 08:27 DATA.30-rw-rw-r-- 1 s000656 dstage 514490368 Jul 25 20:25 OVER.30
-
What is the difference between the routine,transform and function?give some examples for each?
vasanthsolai
- Mar 17th, 2008
Main difference is routines are return the value , transform are cannot return the value..
laxman
- Jul 18th, 2006
routine and function are sounds same, functions are subset of routines..Routine / Function : taking input data and building some buziness logic and give output dataExamples: StringDecode, KeyMgtG...
-
How to develop the SCD using LOOKUP stage?
-
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...
-
Why the sequential file not used in Hash Lookup?
manoharkolukula
- Feb 12th, 2008
Hi Rashmi,Can u please tell me ur telling about server jobs or parallel jobs.If it is server jobs means seq file can't be used as lookup(ref link), bcoz it doesn't accept that link, only hash ...
-
Dataset stage/lookup file stage/file stage
When do one use dataset stage/lookup file stage/file stage in a parallel job?or in other way what is the significance of these files...wat are their differences?
nagoosk
- Feb 28th, 2008
DataSetFile: DataStage PX jobs uses the dataset file to organize the data.Dataset files preserves partitioning means u need not to partition the data when ever u read the data.It maintaines the persis...
-
Debug stages in PX
What are the different Debug stages available in Datastage PX?
Amritendra kumar
- Feb 22nd, 2008
Head, tail, rowgenerator,columngenerator,peek,sample, write range map .
-
How to implement type2 slowly changing dimenstion in datastage? give me with example?
Amritendra kumar
- Feb 22nd, 2008
Shiva is right and he suggested with a great example. You can perform this logic by taking transformer and hashfile stage in server job and if you want to perform scd in parellel then you will have to use change capture and change apply stage.
manoharkolukula
- Feb 12th, 2008
Hello ,He is asking about implementation of type2 in ds, u r telling about type1,type2, type3 history, everybody know what are those things. if u know then tell otherewise leave it.1. we have to use s...
-
How can we increment the surrogate key value for every insert in to target database
-
Conductor Node
What is a conductor node?
nagoosk
- Feb 20th, 2008
Actually every process contains a conductor process where the execution was started and a section leader process for each processing node and a player process for each set of combined operators and a ...
-
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.
-
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?
-
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 you will define Global
How you will define global variables in DS?
ketanshah123
- Feb 19th, 2008
The user variable stage allows you to define global variables within a sequence. These variables can then be used elsewhere in the sequence,The values of the user variables are set by expressions in the stage’s properties
DataStage Interview Questions
Ans