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

Explain usage analysis in datastage?

654


How to read multiple files using a single datastage job if files have the same metadata?

737


Name the command line functions to import and export the DS jobs?

709


What is the difference between server job and parallel jobs?

672


What is staging variable?

624






Where do you see different stages in the designer?

630


table actions available in oracle connector?

1093


what is the use of skid in reporting?

1955


what are the errors,warnings in datastage

2154


Can you highlight the main features of ibm infosphere information server?

635


What are the steps required to kill the job in Datastage?

686


State the difference between an operational datastage and a data warehouse?

606


Difference between data warehousing and olap?

650


What is the importance of the exception activity in datastage?

624


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3758