Answer Posted / sree

use java Transformation(through code we can solve this)

What do you understand by SOA of Informatica?

1043

---

How to join three sources using joiner?

1194

---

What are the different types of olap? Give an example?

1096

---

How do you load alternate records into different tables through mapping flow?

1926

---

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

4239

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1690

---

Why sorter is an active transformation?

1250

---

Enlist some properties of sessions.

1135

---

How to convert multiple rows to single row (multiple columns) in informatica

1426

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1855

---

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

1138

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2087

---

How to use pmcmd utility command?

1077

---

What is workflow monitor?

1099

---

How big was your fact table

1861

---