Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

---

How do you get log info into a file?

1 Answers  

---

What is the sortmerge collector?

0 Answers  

---

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

how to load meta data

2 Answers   IBM,

---

How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,

---

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

---

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---

How do u convert the columns to rows in datastage?

0 Answers  

---

Lookup constraints

0 Answers   CTS,

---