Answer Posted / dhanakkodi

I have two tables emp and dept

i want some employees those who are in the some department
for this situation i have to join two tables.
In this situation both table foreign keys are in the Fact
table means we can easily get the information and also
factless fact table is used for get the count from the
table.

-- Dhanakkodi

can u give example for factless fact table

5527

---

where to store informatica rejected data?

684

---

What is olap (on-line analytical processing?

647

---

What is mapping debugger?

574

---

What is the benefit of session partitioning?

601

---

---

Explain what is informatica metadata and where is it stored?

615

---

As union transformation gives UNION ALL output, how you will get the UNION output?

651

---

What is the format of informatica objects in a repository?

603

---

How to partition the Session?

648

---

Differences between version 7.x and 8.x.

1421

---

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.

1263

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

634

---

What are the types of data warehouses?

948

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1679

---