Answer / bharath

Datastage is an etl tool, enable organizations to extract the information from multiple sources, Transform in the way that make it more valuable and delvers the data into target databases or any applications..

Answer / srinivas

Datastage is a Client and server Technology using this we
can design the jobs,run the jobs and monitering the jobs

What is datastage?

0 Answers  

---

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,

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

---

What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,

---

What is orabulk stage?

0 Answers  

---

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,

---

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,

---

how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,

---

CHANGE CAPTURE

0 Answers   CTS,

---

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---