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.
Answer Posted / ashok
4.in case of only for duplicates removing i will use remove
duplicate stage.but in case of more logics applied i will
go to transformer.bcoz remove duplicate stage give better
performance compare to transformer
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the method of removing duplicates, without the remove duplicate stage?
How many types of views are there in a datastage director?
What are the different kinds of views available in a datastage director?
Define ds designer?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the different type of jobs in datastage?
In Datastage, how you can fix the truncated data error?
Difference between in process and inter process?
What is ds designer?
What are the types of jobs we have in datastage?
Where do the datastage jobs get stored?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is a quality stage in datastage tool?
Differentiate between odbc and drs stage?
Can you implement SCD2 using join, transformer and funnel stage?