Answer Posted / smith

Only those 4 columns in the sql override will be passed to
the next transformation.

What is persistent lookup cache?

1039

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2085

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2133

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2137

---

What is the format of informatica objects in a repository?

1027

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1039

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1020

---

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

1922

---

What is the scenario which compels informatica server to reject files?

1083

---

What are the restrictions of union transformation?

1048

---

Explain sessions and how many types of sessions are there?

1018

---

Why do we need informatica?

1004

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1291

---

What are pre and post-session shell commands?

1325

---

If informatica has its scheduler why using third party scheduler?

1276

---