what is the purpose of surrogate key and diff between primary
It represents one or more fields or attributes that uniquely identified each record in a database table.
surrogate-key:-It is a single part,artificially established identifier an entity,surrogate key assignment is a special case of derived data-one where the primary is derived.A common way that surrogate key values is to assign integer values sequentially.
|Is This Answer Correct ?||5 Yes||1 No|
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
How can you complete unrcoverable sessions?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
How to generate a single mapping for both the historical and incremental load.
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Two Default User groups created in the repository are ____ and ______
what is the diff b/w cached and unchaed look ups