Answer Posted / mahaboob basha

Hi,
the only condition for a transformation to bcum active is
row number changes.
Now the thing is how a row number can change. Then there are
2 conditions:
1. either the no of rows coming in and going out is diff.
eg: in case of filter we have the data like
id name dept row_num
1 aa 4 1
2 bb 3 2
3 cc 4 3
and we have a filter condition like dept=4 then the o/p wld
b like

id name dept row_num
1 aa 4 1
3 cc 4 2

So row num changed and it is an active transformation



2. or the order of the row changes
eg: when Union transformation pulls in data, suppose we have
2 sources
sources1:
id name dept row_num
1 aa 4 1
2 bb 3 2
3 cc 4 3
source2:
id name dept row_num
4 aaa 4 4
5 bbb 3 5
6 ccc 4 6

it never restricts the data from any source so the data can
come in any manner

id name dept row_num old row_num
1 aa 4 1 1
4 aaa 4 2 4
5 bbb 3 3 5
2 bb 3 4 2
3 cc 4 5 3
6 ccc 4 6 6

so the row_num are changing . Thus we say that union is an
active transformation

What could be the possible resons of locks by user?

1144

---

What is union transformation?

1017

---

What is dimensional table?

1133

---

How do you take back up of repository?

1209

---

What is the session task and command task?

1115

---

Explain the features of connected and unconnected lookup.

976

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1960

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2259

---

Which is the t/r that builts only single cache memory?

1239

---

How is union transformation utilized?

1063

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265

---

How do you migrate data from one environment to another?

1149

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1142

---

Differences between version 7.x and 8.x.

1941

---

Have you worked with/created Parameter file

1714

---