Answer Posted / ashok

Source--->Sort stage--->copy stage
From copy stage we have to take two source stages
(source1,source2)
source1-->Removeduplicate stage(in this we can get first
record from each dept)
source2--->Remove duplicate stage(in this we can get last
record from each dept)
using funnel we can add these results.

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.

4044

---

What is the difference between an operational datastage and a data warehouse?

1154

---

What is the difference between orabulk and bcp stages?

1027

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

---

How do you schedule or monitoring the job?

1210

---

Define oconv () and iconv () functions in datastage?

1416

---

Can you define merge?

1123

---

How to find value from a column in a dataset?

2203

---

Differentiate between hash file and sequential file?

1073

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1216

---

Can you explain kafka connector?

1312

---

I have a few records just I want to store data in to targets cycling way how?

2365

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2244

---

How and where you used hash file?

1175

---

Define Data Stage?

1096

---