Answer Posted / sunil

Its not very clear by using expression transformation.Can
any one eloberate. I am creating one variable port VAR_EMPNO
in exp and giving value as EMPNO.Created one output port
EMPVAR_OP with cond : IFF(EMPNO = VAR_EMPNO,1,0) Based on
this I am filtering and redirecting to two targets but its
not working, is the expression fine over here?

Separate from an archive server and a powerhouse?

1007

---

What is the scenario which compels informatica server to reject files?

1122

---

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

---

how to load dimension table and fact table. plz tell me the steps.

2142

---

Explain Dataware house architecture .how data flow from intial to end?

2647

---

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

1186

---

How to create the source and target database connections in server manager?

1130

---

How to generate sequence numbers using expression transformation?

1148

---

Differentiate between joiner and lookup transformation?

1159

---

How does a rank transform differ from aggregator transform functions max and min?

1263

---

Write the advantages of partitioning a session?

1332

---

What is rank transformation?

1035

---

Briefly explain the aggregator transformation?

1066

---

What are the data movement modes in informatica?

1208

---

Differentiate between router and filter transformation?

1064

---