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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Explain entity, attribute and relationship in datastage?
What are the functionalities of link partitioner and link collector?
What is usage analysis in datastage?
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
How to read the length of word in unix?
how to write server Routine coding?
What are stage variables, derivations and constants?
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...
How complex jobs are implemented in datstage to improve performance?
How do you generate sequence number in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is orabulk stage?
What is "fatal error/rdbms code 3996" error?
What are sequencers?