Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

Why fact table is in normal form?

0 Answers  

---

How do u convert the columns to rows in datastage?

0 Answers  

---

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

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,

---

What are the steps needed to create a simple basic datastage job?

0 Answers  

---

What is a ds designer?

0 Answers  

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

What could be a data source system?

0 Answers  

---

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---