Answer Posted / venkatesh.malneni

let us take the metadata as name and records ok,
in expression t/r we create a new o/p port in that write the
expression as name ||''||record||''||records||''|| times


connect the newly created o/p port to the target.

What is informatica etl tool?

985

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2138

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2090

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2265

---

How to update or delete the rows in a target, which do not have key fields?

1164

---

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?

955

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2255

---

What are the measure objects?

1185

---

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

1897

---

tell me the rules and responsblites in our project(my project is development)

1917

---

How many transformations can be used in mapplets.

1908

---

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

1097

---

Differences between connected and unconnected lookup?

1201

---

How can we use mapping variables in informatica?

1037

---

What is xml source qualifier transformation in informatica?

1204

---