Answer Posted / sujatha

I think its wrong ...because aggr is an active trans and
exp is a passive trans....

as per the infa help ...
"You cannot connect an active transformation and a passive
transformation to the same downstream transformation or
transformation input group."....

Where is metadata stored?

1195

---

What is an active transformation?

1159

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2247

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7503

---

What is flashback table ? Advance thanks

1998

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128

---

Global and Local shortcuts. Advantages.

2091

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2256

---

What is the use of source qualifier?

1186

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2312

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1098

---

What are the differences between a connected lookup and unconnected lookup?

1126

---

How many ways are there to create ports?

1404

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2410

---

How to convert multiple rows to single row (multiple columns) in informatica

1429

---