Answer Posted / shiva

understanding the transfromatin language,and analize the
tranfromation language time being taken to achieve the
taske ,then push the trasnformtin logic either source
database or targer database.

Where are the source flat files kept before running the session?

1088

---

Can we create multiple integration service on single repository?

1197

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2033

---

What are the differences between oltp and olap?

976

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1910

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1802

---

What is aggregate cache in aggregator transformation?

1151

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1152

---

What is the need for an etl tool?

1071

---

What is meant by active and passive transformation?

1131

---

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

1054

---

How to extract sap data using informatica?

1047

---

What is an Integration service in Informatica?

1137

---

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

1917

---

Explain dynamic target flat file name generation in informatica

1063

---