Answer / sudheer113

 The Designer does not allow you to connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group because the Integration Service may not be able to concatenate the rows passed by active transformations. For example, one branch in amapping contains an Update Strategy transformation that flags a row for delete. Another branch contains an Update Strategy transformation that flags a row for insert. If you connect these transformations to a single transformation input group, the Integration Service cannot combine the delete and insert operations for the row.

What is informatica powercenter repository?

0 Answers  

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

---

How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

What is informatica?

0 Answers  

---