Answer Posted / santosh

Follow the below step.
1.Take the sorter transformation and sort by empid(IF some cases empid not in sequence).
2.Take a expression transformation with below condition.
a. CURRENT_ID=EMPID
b. EMPID=EMPID
C. name=name
d. NAME_VAR= IIF(CURRENT_ID = NEXT_ID,(NAME_VAR ||name ),name)
e.NAME_OUT= NAME_VAR
f. NEXT_ID= CURRENT_ID
3.Take a aggregator transformation and give group by port as empid.

Could you explain what is enterprise data warehouse?

1224

---

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

8296

---

Whats there in global repository

1737

---

Explain pmcmd command usage in informatica

1187

---

How would you copy the content of one repository to another repository?

1058

---

What is the difference between Active and Passive transformation?

1220

---

What is informatica etl tool?

1059

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1711

---

What is resilience time?

1227

---

What is the Rank index port in Rank transformation?

1102

---

What is complex mapping?

1171

---

What are the reusable transformations?

1219

---

What is joiner change?

1191

---

can we override a native sql query within informatica? How do we do it?

1186

---

explain one complex mapping with logic? sales project?

6733

---