if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?5 10659
how to transfer file from one system to another system in unix? which cmd to be use?5 11078
how many stages are there in Datastage... Please clarify mee??3 5968
I 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 10138
Explaine 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 advance1238
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.10 10662
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?5 6518
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???3 18776
1.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 11300
what is use of SDR function?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are iconv and oconv?
How do you remove duplicate values in datastage?
whom do you report?
Where do you see different stages in the designer?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is difference between server jobs & parallel jobs?
Give an idea of system variables.
How do you register plug-ins?
Differentiate between Join, Merge and Lookup stage?
options available in sequence job to run,validate?
What is the difference between orabulk and bcp stages?
How many Key we can define in remove duplicate stage?
Is the value of staging variable stored temporarily or permanently?