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!

What are the various kinds of containers available in datastage?

1101

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2444

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1324

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2411

---

table actions available in oracle connector?

1658

---

Which warehouse using in your datawarehouse

2239

---

What is the precedence of stage variables,derivations, and constraints?

1127

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2295

---

How to manage date conversion in Datastage?

1188

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2260

---

Describe link sort?

1060

---

What are the difference types of stages?

1287

---

What is data partitioning?

1270

---

How many types of sorting methods are available in datastage?

1116

---

What is ds designer?

1166

---