Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / prince
Hi Venu, The definition you said for Fastly Changing Dimensions is true, but can you give one more example of a entity that changes frequently. Because ATM transactions will be loaded into FACT TABLE as that is a TRANSACTIONAL DATA but it is not loaded to DIMENSION TABLE.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
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 are routines in datastage? Enlist various types of routines.
On which Dimension Table you implemented SCD Type in your Project
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is data partitioning?
What are the different common services in datastage?
what is use of SDR function?
Give an idea of system variables.
What are the functionalities of link partitioner?
in oracle target stage when we use load option and when we use upsert option?
What is the difference between server job and parallel jobs?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the different kinds of views available in a datastage director?
What is a merge in datastage?
