Answer Posted / rameshgoud

scd1-> with this process we can maintain only updated data,
for ex- if a record inserted in source then the same record
should be inserted in targer, if a record updated in the
source then same update should process in target, so here
we cant maintain the history

scd2->with this we can maintain current data and complete
historical data by adding the start_date and end_date of
the records in the target table. If a records get updated
in the source same record will insert in the target as new
record and the old record is updated with end date as
todays date. Like wise we there will no be any deletion of
records, so we can maintain the compelte history here.

scd3-> using this we can maintain current and recent
historical data only
for every source possible changing column we need two
target columns as NEW_COLUMN indicates current data and
OLD_COLUMN indicates recent historical data
when a new record getting loaded source data is always
loded in NEW_COLUMN in target
when a record is midified target NEW_COLUMN is updated in
target OLD_COLUMN and source data is updated in target
NEW_COLUMN.

Can you explain kafka connector?

1243

---

What are the types of containers and how to create them?

930

---

What is a quality stage in datastage tool?

1023

---

Can you implement SCD2 using join, transformer and funnel stage?

1496

---

EXPLAIN SCD

1338

---

how can we create rank using datastage?what is the meaning of rank?

8705

---

What is use Array size in datastage

1719

---

What are the different options associated with dsjob command?

1370

---

What are orabulk and bcp stages?

1067

---

How to implement complex jobs in data stage?

1049

---

client know skid info?

2034

---

What are the difference types of stages?

1134

---

Differentiate between datastage and informatica?

1140

---

whom do you report?

1879

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2176

---