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.

0 Answers  

---

how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,

---

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

---

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

---

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

---

Define Merge?

0 Answers  

---

what is mapping lookup

1 Answers  

---

what is a nodemap constraint

2 Answers   IBM,

---

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers   Cognizant, IBM, TCS, Virtusa,

---

Define project in datastage?

0 Answers  

---

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---