Interested to Buy Any Domain ? << Click Here >> for more details...
Hai..,This Kiran .
how to immlement SCD's through sequential file.please
explain briefly.if nt ask me i will explain ,what i know.
- 2 Answers
- 6118 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashutosh g
Hi,
SCD means Slowly Changing Dimensions.
There are multiple ways to solve this. However, here are
the three main types:
Type1 : The new record replaces the original record. No
trace of the old record exists.
Type2 : A new record is added into the customer dimension
table with an Active flag or something. Therefore, the
customer is treated essentially as two people. This is the
most popular method.
Type3 : The original record is modified to reflect the
change. Essentially, this method requires adding a new
column to reflect the change. This is very seldom used.
source-->LookupTransform---->transform--->Target DIm
|
Hashfile
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the differentiate between data file and descriptor file?
What is ibm datastage flow designer?
I have a few records just I want to store data in to targets cycling way how?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
how to abort the job its matain duplicates?
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 are the primary usages of datastage tool?
What are the various kinds of the hash file?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between datastage and informatica?
How do y read Sequential file from job control?
Differentiate between datastage and datastage tx?
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?
