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
What is the difference between informatica and datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the roundrobin collector?
What is the project in datastage?
What are iconv and oconv?
What is the purpose of pivot stage and types of containers in datastage
How many types of stage?
What are the processing stages?
What are the functionalities of link partitioner?
What is the sortmerge collector?
What is a merge?
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.
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How can we improve performance of data stage jobs?