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?
Answer Posted / madhav
canu give ans in depth
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How a routine is called in datastage job?
Name the third party tools that can be used in datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How to find value from a column in a dataset?
How one source columns or rows to be loaded in to two different tables?
Is possible to create skid in dim,fact tables?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the use of datastage designer?
What is the difference between validated and compiled in the datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the difference between orabulk and bcp stages?
How do you schedule or monitoring the job?
What is the difference between server job and parallel jobs?
What are the functionalities of link collector?