Answer Posted / sree

select sal from emp e where nth=(select count(*) from emp
where sal>e.sal);

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1006

---

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

4129

---

What do you understand by a term domain?

1061

---

How would you join a node to the already existing domain?

1066

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1102

---

How do you migrate data from one environment to another?

1041

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2253

---

What are ETL Tools?

1039

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2677

---

What is a mapplet/worklet in informatica?

1120

---

What is the meaning of up gradation of repository?

1895

---

Enlist the tasks for which source qualifier transformation is used.

980

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

998

---

Explain in detail scd type 2 through mapping.

986

---

How can you validate all mappings in the repository simultaneously?

1287

---