DataStage FAQ
By using lookup we join the data from more than one table, we can implement the same using join stage, then what is the need of lookup stage especially in datastage?
Sequential file stage duplicates
How to remove duplicates through only sequential file stage?
To remove duplicates from a sequential file, use filter property of sequential file stage. Put "sort | uniq" in filter and it will remove duplicates from file and in output it will have all unique records.Hope this helps.
Calculation without using aggregator
How to calculate sum, averages, minimum, maximum salaries of an employee without using aggregator stage in datastage?
Ofcourse by using Tranformation Stage we can do this
How to extract your flat files using sequntial file or dataset? From where to get these flat files as source?
Flat files can be accessed from unix by using sequential file stage. For example if we are having csv file . we can give the path in the sequential stage for this file and we can access the file directly.
How to find job endtime?
Job end time can be found in Director > job log
How to improve the performance while reading data through sequentilal file?
We can use the Number of readers per Node property to enhance parallelism in Sequential file, hence enhancing the performance..
Src has 1 record I want 10records in target how is it possible ? Plz explain me ?
source-copy stage take ten out links from copy stage-link it to funnel stage-sequential file in this way we can get 10 records in output
Diff between userdefined environment variables and parameter sets
Hi all, pls let me know the purpose of using user defined environment variables and parameters sets
An user defined environment variable is a place holder to store a value that can used in the entire project. Parameter set is new time saving feature added in DataStage 8x. Parameter set is set of jo...
What is host name in datastage?
nothing but server name
How is design (fact and dimension) of fact table type 2 (keep historical value)
How can I import meta data from quality stage to data stage?
Does datastage work with byte stream, binary files
?A byte stream file was ftp'd from an hp3000 mpe/ix server to the etl server (windows 2000). The column values are enclosed in double quotes (") and the spaces within these are not lost comma (,) is the column delimiterhowever, the newline character is converted to binary (vertical rectangular box) and...
How to deinstall datastage v8.0.1.2 server on aix, properly.
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
Interview Question
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
NH
Datastage lookup has some additional benefits over join stage :a) A lookup stage supports reject link which is not supported by join stage.b) Lookup stage has an option to fail the job if the lookup f...