Answer / srinivas

We can do this by using the sort stage.

Specify the key columns what ever the you are sort.

Specify column name sort specifications
For example i have 3 columns data like below

Name score rank

abc 85 1
bcd 74 3
abc 82 2
bcd 67 4

When u r sort based on first two colmns

u have to specify two colmn names and specificaton

Like: Name Asc, Score Dsc.

Then u will get the output like below.

Name score rank
abc 85 1
abc 82 2
bcd 74 3
bcd 67 4

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

Define Merge?

0 Answers  

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

---

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

What is the difference between datastage and informatica?

0 Answers  

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

How a source file is populated?

0 Answers  

---

Difference between server jobs & parallel jobs?

0 Answers  

---

How complex jobs are implemented in datstage to improve performance?

0 Answers  

---

What all are the different way to run a job?

0 Answers  

---

What is lookup table?

5 Answers  

---