How to Remove Duplicate using SQL?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

How complex jobs are implemented in datstage to improve performance?

0 Answers  


Why we use parameters instead of hard code in datastage.

2 Answers   IBM,


What is job control?

0 Answers  


source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,


whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,






3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  


i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,


Explain the functionality of your current project?

1 Answers   IBM, Miles Software,


What is use Array size in datastage

0 Answers  


what is mapping lookup

1 Answers  


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  


Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,


Categories