Answer Posted / ambarish

In the workflow manager you have option go to workflow----
>EDIT---check this box suspend on error
if the work fails after loading 10000 records with error
you can correct the error and restart the workflow which
will load strating from 10001.

Define update strategy?

1234

---

What is meant by lookup transformation?

1111

---

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

2129

---

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

1915

---

Explain scd type 3 through mapping.

1022

---

explain abt ur project architecture?

2198

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1933

---

What is a stored procedure transformation?

1057

---

What are the components of Informatica? And what is the purpose of each?

1056

---

What is workflow manager?

1054

---

What are the different options available for update strategy?

1005

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1133

---

What are mapplets?

1277

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1088

---

What are the data movement modes in informatica?

1164

---