Answer / bhageerath

src->sq->exp->aggr->tgt

src(col1[int],col2[varchar])

sq(col1[int],col2[varchar])

exp(col1,,col2,v_col1,v_col2,o_col2) {v=variable port, o=output port}

imp:
{ v_col1=col1; v_col2=iif(col1!=v_col1, col2, v_col2||" "||col2); o_col2= v_col2}

aggr(col1,o_col2)

tgt(col1,col2)

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

---

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

what is flat file override?

1 Answers   Cap Gemini, HP,

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---