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?
- 5 Answers
- 14851 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
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
Can you define merge?
whom do you report?
Difference between sequential file and data set?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Define ds designer?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What all the types of jobs you developed?
What is process model?
How a server job can be converted to a parallel job?
describe the Steps to confiure a Qlogic switch
What are the types of containers in datastage?
Describe the architecture of datastage?
Define project in datastage?
I have a few records just I want to store data in to targets cycling way how?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
