Answer Posted / kalyanreddy

Hi Vyas,

Please ask the question properly....
Other wise you wont get right ans...

There are two posibilities
1.

table 1 has 4 col..
like
a,b,c,d
table 2 has 3 col..
like
a,b,c
table 3 has 2 col..
a,b

In this case funnel stage give only two output columns
(consider same metadata)
which are common in all the table ( in funnel stage no
properties are there for selecting common columns from
input).


2.

If Metadata is not same in above table change metadata in
transformer stage before using funnel based on requirement
only and consider datatypes of the columns.

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2237

---

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

2369

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2974

---

What is meta stage?

1188

---

How can you write parallel routines in datastage PX?

1019

---

How to implement complex jobs in data stage?

1116

---

Have you have ever worked in unix environment and why it is useful in datastage?

1134

---

AGGREGATOR default datatype

1463

---

options available in sequence job to run,validate?

1325

---

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)

2389

---

Describe routines in datastage? Enlist various types of routines.

1016

---

what is ds administrator used for?

1175

---

Can you filter data in hashed file?

3780

---

What is ibm datastage?

973

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1384

---