How can we achive parallelism

1 Answers   CTS,

---

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,

---

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  

---

Why we use surrogate key?

0 Answers  

---

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

Define orabulk and bcp stages?

0 Answers  

---

How do you design PX Routines ?

1 Answers  

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

0 Answers   JPMorgan Chase,

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  

---

How to RD using transformer?

0 Answers   CTS,

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---