Answer Posted / kiran

Hai..,
This is Kiran.
In SCD's type we r using change capture and transfernar
stage.
date fields are using in target level as Eff_start_date and
Eff_end_date.

Eff_start_date=current date
Eff_end_date =Currentdate-1.

If any mail me

Regards
Kiran
9393363309

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1634

---

Differentiate between Join, Merge and Lookup stage?

644

---

Can we use target hash file as a lookup ?

2814

---

Does datastage support slowly changing dimensions ?

659

---

Name the third party tools that can be used in datastage?

611

---

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2270

---

How do you import and export data into datastage?

699

---

What is difference between server jobs & parallel jobs?

623

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1716

---

Whats difference betweeen operational data stage (ods) and data warehouse?

667

---

What are the main features of datastage?

660

---

In Datastage, how you can fix the truncated data error?

640

---

Is possible to create skid in dim,fact tables?

2187

---

How many types of sorting methods are available in datastage?

629

---

How to implement complex jobs in data stage?

612

---