Answer Posted / aryan verma

Hello mukesh,
Please do help me with the dumps for the Informatica certification for designer.I am planning to attend this month.
email:aryanverma_1604@yahoo.co.in
Thanks in advancve
Aryan

Write the unconnected lookup syntax?

1030

---

What is dimensional table? Explain the different dimensions.

1110

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2350

---

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

982

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2389

---

What are the restrictions of union transformation?

977

---

What are Dimensional table?

999

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

915

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2293

---

can you please explain me pre session and post session options?

7402

---

how to create user defined function (udf) in informatica

1243

---

How to create a non-reusable instance of reusable transformations?

1058

---

How can we use mapping variables in informatica?

1002

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1842

---

What is mapplet in informatica?

982

---