Answer Posted / chandu

Hello All,
I have a query to all of u guys...
U all said If any t/r changes the number of records it is a
active ritee....?

So here my query is about Union t/r, In Informatica by
default Union t/r acts as Union all means allow duplicates..

If I have 2 sources having 20 records each after union t/r
the result should be 40 records so, there is no change in
records, even then it is an active t/r yyyyyyyy?

What are data-driven sessions?

1181

---

Explain constraint based loading in informatica

1076

---

What is primary and backup node?

1111

---

Does an informatica transformation support only aggregate expressions?

1020

---

What is domain and gateway node?

1152

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1479

---

What are the new features of Power Center 5.0?

1752

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8045

---

What is a joiner transformation?

966

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9808

---

What are the types of lookup transformation?

1055

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2179

---

What is decode in informatica?

1122

---

Explain transaction control transformation in informatica

1247

---

How can we handle two sessions in informatica?

1018

---