How to remove duplicates in transformer stage? in parallel
mode

Answer Posted / santhosh

go to transformer stage properties->input->define any kind of partition over there and enable perform sort check box....

n also define the particular column need to be sorted..

it gives the sorted column out view...

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

669


Can you define merge?

670


On which Dimension Table you implemented SCD Type in your Project

1588


What is the difference between datastage and datastage tx?

600


How do you schedule or monitoring the job?

676






What are system variables and sequencers in datastage

615


what is the difference between == and eq in UNIX shell scripting?

981


what is flow of project?

1561


What are the various kinds of containers available in datastage?

571


What is orabulk stage?

640


What is the difference between odbc and drs stage?

645


Differentiate between datastage and datastage tx?

601


What are the enhancements made in datastage 7.5 compare with 7.0?

713


What is the difference between orabulk and bcp stages?

581


Highlight the main features of datastage?

619