Answer / datastage4you

You can generate seq no by, column generator or transformer

http://goo.gl/atN4AT
www.datagenx.net

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  

---

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,

---

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,

---

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

---

Main Function of the Staging area in DWH ?

2 Answers  

---

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,

---

Terminate Activity

0 Answers   CTS,

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

What is the difference between passive stage and active stage?

0 Answers  

---

Why do we use exception activity in Datastage?

0 Answers  

---

Explain entity, attribute and relationship in datastage?

0 Answers  

---