Answer Posted / santosh

HI ARUNAKUMARI,

IAM RAJU,WHAT IS MAPPPING DESIGN OF THIS SCENARIO AND WHERE WE DESIGN LIKE IN TRANSFORMER STAGE OR ANY AND WHAT IS(variableports)& WHICH STAGES ARE SQ AND EXP AND SORTER.
IAM A NEW IN DATASTAGE,PLS EXPLAIN ABOUT THIS CLEARLY

THANKS ADVANCE.
(here column names are not mentioned .so,i have taken them
as column1 and column2)

take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.

(variableports)curr_col1_val:column1

(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)

(variableports)pre_col1_val:column1

What is powercenter on grid?

699

---

waht type of interface is used for testing the data in informatica

1838

---

Differentiate between router and filter transformation?

617

---

Define Pmrep command?

642

---

What do you understand by term role-playing dimension?

585

---

---

Explain target update override in informatica

635

---

What is incremental aggregation?

577

---

what is degenerated dimension?

3160

---

How do you load first and last records into target table?

672

---

How do you promote a non-reusable transformation to reusable transformation?

665

---

Define sessions in informatica etl?

619

---

What is update strategy transform?

580

---

How many input parameters can exist in an unconnected lookup?

1004

---

What is the way to execute pl/sql script using informatica mapping?

969

---

What are the performance considerations when working with aggregator transformation?

678

---