explain how to create SCD-2 IN DATASTAGE 7.5X2
PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE
AND JOB DESINGN URGENT
Answers were Sorted based on User's Feedback
Answer / harikiran
we can implement scd-2 in ds 7.5.2 server jobs by using
hash file and transformer stage. here hash file can act as
a lookup table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / guest
http://etl-tools.info/en/datastage-tutorial-L008_scd-implementation-datastage.htm
| Is This Answer Correct ? | 0 Yes | 0 No |
How did you reconcile source with target?
How many types of hash files are there?
explain about citrix scheduling tool in datastage
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
How will you move hashed file from one location to another location?
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?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
data stores in which location while using data set stage as the target?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
What are some prerequisites for datastage?