how CAN we remove duplicates in dataset?
Answers were Sorted based on User's Feedback
Answer / disney
In dataset stage, Input tab of partitioning --> used the key
partition instead of auto partition , then check the
perform sort and check the unique, It will remove the
duplicate from dataset
| Is This Answer Correct ? | 25 Yes | 0 No |
Answer / markonda
by using remove duplicate stage we can remove duplicates
| Is This Answer Correct ? | 3 Yes | 6 No |
what is ds administrator used for?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
Highlight the main features of datastage?
how can u find out the datastage job is running on how many nodes
what is a message handler
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
sed,awk,head
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the types of views in datastage director?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
which r the connectors used in san?
How do u view log file for a particular job?