Answer Posted / dev

A Fact table without numeric fact column is called factless
face.

What does reusable transformation mean?

1116

---

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.

1677

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1927

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2219

---

scenario where i can use only concurrent execution of workflow.

3138

---

What is repository manager?

968

---

Explain why we use partitioning the session in informatica?

1068

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2115

---

Define Pmrep command?

1028

---

What is rank index in rank transformation?

1055

---

How many ways a relational source definition can be updated and what are they?

992

---

Define pmcmd command?

1024

---

What is the status code in stored procedure transformation?

1163

---

What is workflow? What are the components of the workflow manager?

1100

---

Differentiate between joiner and lookup transformation?

1090

---