Answer Posted / usha

we can run 2 workflows sequentially.

by creating 2 WL..

wl contains set of reusable session..

wf---->wL---->wL

if 2 wf are in same repository..


===============================
if 2 wf are in different repository we set the dependence..
by using shell script..

script one is used to run the first wf..
after running the wf1 it will creates a zero bye file..

if it doesnt not create zero bye file it will for 6loop
times..each loop will wait for 5min..for zero bye file

if file avalible it will start running the second script to
run second WF..if file not avalibel..

i will send a mial...
by using mailX command

explain one complex mapping with logic? sales project?

6657

---

what is the -ve test case in your project.

2400

---

Enlist the advantages of informatica.

1062

---

What is the use of code page?

1083

---

What are the reusable transformations?

1154

---

scenario where i can use only concurrent execution of workflow.

3161

---

What are the differences between oltp and olap?

969

---

What is informatica? Why do we need it?

1092

---

explain abt ur project architecture?

2184

---

How do you change a non-reusable transformation to reusable transformation?

993

---

What are the static cache and dynamic cache in informatica?

1181

---

Which development components of informatica have the highest usage?

1030

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1687

---

What is the fact table?

1058

---

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

4180

---