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,

---

what is a message handler

3 Answers   IBM,

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---

How to reverse the string using unix?

0 Answers   CTS,

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

1 Answers   IBM,

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

---

How can you join flat file, oracle as a sources?

4 Answers   IBM,

---