Answer Posted / swetha

In case of storedprocedure transformation procedure will be
compiled and executed in a relational data source.yoU need
data base connection to import the stored procedure in to
your maping.Where as in external procedure transformation
procedure or function will be executed out side of data
source.Ie you need to make it as a DLL to access in your
maping.No need to have data base connection in case of
external procedure transformation.

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

1902

---

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?

966

---

What is the use of code page?

1083

---

How to update source definition?

1082

---

Scheduling properties,whats the default (sequential)

1947

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1050

---

What are the differences between oltp and olap?

969

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1079

---

Design a mapping to load a target table with the following values from the above source?

1338

---

How many ways are there to create ports?

1325

---

What are the advantages of using informatica as an etl tool over teradata?

1018

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2061

---

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

1152

---

What does “tail –f” command do and what is its use as an Informatica admin.

1098

---

what is diff b/t sorter t/r and agg have the option sorter property...

2169

---