Answer / chethankumar km

using Pivot stage
seq--->pivot--->dataset
in pivot output col name one same as city second one as
company in that col in derivation name1,name2,name3,name4.
compile and run will get desired output.

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

what is advantages of snowflake when it is used?

3 Answers   IBM,

---

what is sparse lookup?

7 Answers   IBM,

---

what is hash file

2 Answers   CTS, IBM,

---

What is RCP

5 Answers   CGI, CTS,

---

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  

---

What is the difference between an operational datastage and a data warehouse?

0 Answers  

---

What is difference between server jobs & parallel jobs?

0 Answers  

---

how do u reduce warnings

1 Answers   CGI,

---

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

---