Answer / hanug

The DB tables will be created in two ways

1. By right clicking on on the navigator on any of the
folder, you can choose NEW -> Table definition

2. We can also create new table using Database stages.

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

---

Can you filter data in hashed file?

0 Answers  

---

What are the repository tables in datastage?

0 Answers  

---

what is repositery?

0 Answers   IBM,

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---

---

How do you reject records in a transformer?

0 Answers  

---

Explain connectivity between datastage with datasources?

0 Answers  

---

How to reverse the string using SQL?

0 Answers   CTS,

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,

---