Answer / Purnima Tiwari

The components of the Informatica Workflow Manager include:
1. Repository: A centralized storage for all objects, including transformations, sessions, workflows, and connections.
2. Workflow Editor: A graphical interface for designing, configuring, and managing workflows.
3. Transformation Designer: A tool for creating and modifying individual data transformations.
4. Session Manager: Manages the execution of workflows, tracking their status, errors, and dependencies.
5. Monitoring and Reporting Tools: Provides insights into workflow performance, errors, and throughput.

What is the way to execute pl/sql script using informatica mapping?

1 Answers  

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1 Answers   Patni,

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

How informatica process data means how informatica works?

2 Answers   TCS,

---

What is an expression transformation?

1 Answers  

---

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

---

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

---