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,

---

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,

---

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers   TCS,

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

difference between server shared container and parallel shared container

6 Answers   CTS,

---

How many areas for files does datastage have?

0 Answers  

---

CHANGE CAPTURE

0 Answers   CTS,

---

How did you reconcile source with target?

2 Answers   HP,

---

On which interface you will be working as a developer?

0 Answers  

---