Answer / sarath

We can not say this is/isnt a migration project based on your query.For many projects we get the data from mainframe or as flat file
Migration project means the entire code is developed in one technology ( lets say eg: SAS) and now they want to implement the same code in new technology ( say now DATASTAGE) for better performance. as it will take more time to complete the job in SAS compared to datastage. finally the goal is optimization.

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

---

can explain wt is the pool for file.

1 Answers   CTS,

---

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,

---

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

1 Answers  

---

How to Remove Duplicate using SQL?

0 Answers   CTS,

---

what is mapping lookup

1 Answers  

---

Differentiate between hash file and sequential file?

0 Answers  

---

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

---

Where do the datastage jobs get stored?

0 Answers  

---

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,

---