how do u capture duplicates through sort & transformer
Answer Posted / kiran
Hai..,
In sort stage we have one property...its create key change
column.
In Transformer stage ,we have to write if then else
condition.....
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What are the types of jobs we have in datastage?
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 advance
Lookup constraints
Define meta stage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are stage variables and constants?
What is the difference between validated and compiled in the datastage?
What are the functionalities of link partitioner?
What is a quality stage in datastage tool?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is difference between server jobs & parallel jobs?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Differentiate between operational datastage (ods) and data warehouse?
What is oci?
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