if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
5 15311I 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 12853Explaine 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
2179insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
5 10130I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
3 220021.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 15165
What is ibm datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Why do we use exception activity in Datastage?
What are routines in datastage?
Define orabulk and bcp stages?
How you can fix the truncated data error in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
Define meta stage?
Give an idea of system variables.
What are the primary usages of datastage tool?
Explain the situation where you have applied SCD in your project?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Define repository tables in datastage?
What are the main features of datastage?
Name the command line functions to import and export the DS jobs?