Answer / smarati

It is active transformation because,

- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition

All the above increases/decreases the number of rows, so SQ
is active.

Thanks
Som

Answer / sushma

SQ transofrmation reads the rows from the source. It is an
active transformation.

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

---

what is degenerated dimension?

1 Answers   IBM,

---

What is a poling?

2 Answers  

---

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

---

What are the scheduling options to run a sesion?

2 Answers  

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

what is confirmed dimension?

6 Answers  

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---