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)

Explain what is informatica metadata and where is it stored?

0 Answers  

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

what is the difference between onsite & client site?

1 Answers  

---

Why we require dwh in particular projects?

1 Answers   Amdocs,

---

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

---

How we can create indexes after completing the load process?

0 Answers  

---

What is a test load?

1 Answers  

---