Answer Posted / isha_gtb

Enable Test Load : You can select this option to allow only a few records to
pass through the mapping. This option is useful when
you are in the testing phase of your project.


Number of rows to test : When you select the Enable Test Load option, you
can define the number of records you wish to flow
from Mapping. Suppose you have 10,000 records to
process. You can check the Enable Test Load option
and mention the number of records you wish to test. So,
if you define 100 records, Informatica will only process
100 records out of the 10,000 records.

differences between service based and product based?

2010

---

What does update strategy mean, and what are the different option of it?

1089

---

What are the differences between joiner transformation and source qualifier transformation?

1171

---

What all join we can perform in LOOKUP transformation?

969

---

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4183

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2192

---

Explain why we use partitioning the session in informatica?

1088

---

What is the difference between informatica 7.0 and 8.0?

1013

---

What are batches?

1096

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1199

---

Does an informatica transformation support only aggregate expressions?

1040

---

What is the need for an etl tool?

1068

---

What is expression transformation?

1093

---

What is event and what are the tasks related to it?

1122

---

How to generate sequence numbers?

1085

---