Interested to Buy Any Domain ? << Click Here >> for more details...
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
5 15669I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
3 13059Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
2266insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
5 10485I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
3 222121.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
4 15519
How many areas for files does datastage have?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Differentiate between Join, Merge and Lookup stage?
What are stage variables?
Have you have ever worked in unix environment and why it is useful in datastage?
Define repository tables in datastage?
What are the types of hashed files in data stage
sed,awk,head
root tree will find which is server job and which is parallel job?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the primary usages of datastage tool?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is aggtorec restructure operator?
CHANGE CAPTURE
How do you reject records in a transformer?
