Answer / xyz

3 types
1.source level:while importing file,we get option in properties for sorting
2.link level: traditional sorting(ascending or descending)
3.processing level:where there is a separate stage provided for sorting 

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

---

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,

---

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

---

what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,

---

Nls stands for what in datastage?

0 Answers  

---

---

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

---