Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

What are routines in datastage?

0 Answers  

---

Which warehouse using in your datawarehouse

0 Answers   IBM,

---

What is a range lookup?

2 Answers   IBM,

---

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

---

What is the precedence of stage variables,derivations, and constraints?

0 Answers  

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---

What is staging variable?

0 Answers  

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---