1.how to generate even numbers in surrogate or tranformar
stage ?

2. how many ways to remove duplicate values?

Answer Posted / kumar

By using distinct we can eliminate duplicates,
by using variable comparison we can eliminate duplicates.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between Join, Merge and Lookup stage?

641


Explain datastage architecture?

808


how to add a new records into source?

1519


What are the features of datastage flow designer?

623


What are the difference types of stages?

618






CHANGE CAPTURE

883


What is the purpose of interprocessor stage in server jobs?

1722


What is difference between server jobs & parallel jobs?

617


describe the Steps to confiure a Qlogic switch

1931


How to implement complex jobs in data stage?

608


What is the difference between odbc and drs stage?

633


How do y read Sequential file from job control?

14393


How do you schedule or monitoring the job?

657


what is the use of surogate key in datastage

1809


What is the method of removing duplicates, without the remove duplicate stage?

576