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...

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

2. how many ways to remove duplicate values?

Answer Posted / kiran

IN surrogate key generator stage set the block size to 2
with initial value as 2, it will increment the surrogates
by 2 and will get you even numbers. I don't think in any
real world scenario you would do this as it violates
surrogate key concept. I wish the interviewer knew this
before he/she asked you.

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you start developing a datastage project?

1056


What are the partitioning techniques available in link partitioner?

2225


Have you have ever worked in unix environment and why it is useful in datastage?

1080


What are the types of containers in datastage?

1140


what is the use of skid in reporting?

2307


What is the difference between datastage and informatica?

1058


What is difference between symmetric multiprocessing and massive parallel processing?

1078


How to perform incremental load in datastage?

1121


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2443


What is the purpose of pivot stage?

1094


Difference between in process and inter process?

1162


What are the functionalities of link collector?

1032


Whats difference betweeen operational data stage (ods) and data warehouse?

1069


Explain how a source file is populated?

1307


Define orabulk and bcp stages?

1064