if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
5 15500I 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 12963Explaine 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
2224insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
5 10324I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
3 221321.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 15366
How to Remove Duplicate using SQL?
What are the functionalities of link collector?
How to perform incremental load in datastage?
what is the use of surogate key in datastage
What is the difference between hashfile and sequential file?
How do you schedule or monitoring the job?
How a source file is populated?
Distinguish between informatica & datastage. Which one would you choose and why?
Why do we use exception activity in Datastage?
Which algorithm you used for your hashfile?
What is the process of killing a job in datastage?
What is the difference between datastage and datastage tx?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the functionalities of link partitioner and link collector?
How to reverse the string using unix?