Answer Posted / sarita

Hi Shar,
You aret hardcoding the values in your approach.I think the other approach could be:
1)Take a left outer join on the tables A and B. Common column for join can be a dummy=1.
2)Now output would be 2 columns one will have values 1,2,3,4,5,6,7,8,9,10 other will have NULL....NULL...6,7,...10
in expression transf...take a variable... chk when col a- col b != 0,then put flag X else Y
3)Then similarly do a join for B & C table and use same logic

Hope it works!

Can you explain kafka connector?

1323

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2170

---

How can you write parallel routines in datastage PX?

1030

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2117

---

What is staging variable?

1107

---

EXPLAIN SCD

1416

---

Is the value of staging variable stored temporarily or permanently?

1012

---

What are the various kinds of containers available in datastage?

1063

---

What is a folder? Difference types of stages?

1187

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1017

---

What are stage variables?

1216

---

Can you explain players in datastage?

1216

---

Notification Activity

1423

---

State the difference between an operational datastage and a data warehouse?

1143

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2191

---