How to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,

---

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

---

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,

---

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

---

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,

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

---

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

Triggers,VIEW,Procedures

0 Answers   CTS,

---

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

---

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

---