1.How do u handle NULL in sequential stage.
2.Difference between switch stage and filter stage.
Answer Posted / xxx
in sequvential file,click on columns tab and click on left
side of column then we can provide null field value.
diff between switch and filter is ,switch is expression
based and filter is condition based
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the types of containers and how to create them?
What is usage analysis in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How to convert RGB Value to Hexadecimal values in datastage?
Can you implement SCD2 using join, transformer and funnel stage?
Can we use target hash file as a lookup ?
What steps should be taken to improve Datastage jobs?
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
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the types of jobs we have in datastage?
Define project in datastage?
How a source file is populated?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is a datastage job?