Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


i have a table
col1
10
20
30
40
10
20
50
my requirement is how to retrive only duplicates like
10
10
20
20
like this how it's possible in SQL?

Answers were Sorted based on User's Feedback



i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates l..

Answer / varaprasadsams

Hi Dear,
The above query is 100% correct, i tried.

comming to datastage, source-sort stage-transformer-trg.


in sort stage create keychange column , in tfm choose constraint as zero...sure u wil get...

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Data Stage Interview Questions

how can we create tables in datastage?

1 Answers  


I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,


Have you used Unstructured data?

0 Answers   CTS,


what is mapping lookup

1 Answers  


What is APT_DUMP_SCORE?

2 Answers   IBM,


Where do you see different stages in the designer?

0 Answers  


Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  


SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  


What are data elements?

0 Answers  


What all are the different way to run a job?

0 Answers  


I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,


whom do you report?

0 Answers   NTT Data,


Categories