i have a some records
eno ename acono amount
1001 suresh sbi101 12000
1001 suresh sbi101 14000
1001 is dublicata how can i remove duplicate?
Answer Posted / prasad
by using sort stage also, goto properties tab select alllow
duplicates=false.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain connectivity between datastage with datasources?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How many types of hash files are there?
Define APT_CONFIG in Datastage?
Is the value of staging variable stored temporarily or permanently?
What are the different kinds of views available in a datastage director?
What is the difference between an operational datastage and a data warehouse?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How do you run datastage job from the command line?
Where do you see different stages in the designer?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the differences between datastage and informatica?
What is the sortmerge collector?
What are the some differences between 7.x and 8.x version of datastage?