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

While migrating the data from one environment to another environment how would you manage the connections?

1090

---

What are the databases that informatica can connect to windows?

1054

---

Briefly define reusable transformation?

1131

---

How can you define user defied event?

1031

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

---

What is the format of informatica objects in a repository?

1019

---

What are session parameters ? How do you set them?

1851

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032

---

What is the sequence generator transformation in informatica?

1184

---

what is the hint? how to use it to reduce the query processing in program?

7838

---

Define mapplet?

1013

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

---

Mention some types of transformation?

1048

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2137

---

Write the unconnected lookup syntax?

1084

---