Answer Posted / shiva

In informatica 6.2 union transformation is not pressent and
where as in informatica 7.1 union transformation is present

What are the main features of Oracle 8i with context to datawarehouse?

2074

---

Explain your project of banking domian.

1624

---

How we can use union transformation?

1016

---

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

1870

---

In informatica workflow manager, how many repositories can be created?

1305

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1748

---

How can we update a record in the target table without using update strategy?

1106

---

What is a pre-defined event and user-defined event?

996

---

What is a connected transformation?

1072

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1605

---

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.

2244

---

Why filter transformation is an active one?

948

---

What is a surrogate key?

1036

---

Explain about Informatica server process that how it works relates to mapping variables?

1032

---

Enlist few areas or real-time situations where informatica is required.

1044

---