Interested to Buy Any Domain ? << Click Here >> for more details...
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING
SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT
EVEN IF THE JOB IS COMPILED REPEATEDELY?
- 4 Answers
- 18215 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / kpk
Pass the last key (last primary key or the last value in the
seq) as parameter.
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
Define meta stage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are data elements?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How complex jobs are implemented in datstage to improve performance?
Why fact table is in normal form?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Whats difference betweeen operational data stage (ods) and data warehouse?
How the ipc stage work?
Describe the main features of datastage?
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
What is the roundrobin collector?
how many rows sorted in sort stage by default in server jobs
What are the areas of application?
client know skid info?
