Answer Posted / ajay konidena

No we can't join two flat file with out using joiner ,look
up

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1642

---

write a query to retrieve the latest records from the table sorted by version(scd)

631

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

693

---

What is a pre-defined event and user-defined event?

577

---

Explain pushdown optimization $pushdownconfig parameter - informatica

700

---

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

786

---

What is source qualifier transformation in informatica?

571

---

Differentiate between a database and data warehouse?

652

---

What is dynamic cache?

610

---

How might you approve all mappings in the archive all the while?

602

---

What are roles and groups and benefits of using them?

569

---

what is SDLC way of code development?

1557

---

What is informatica? Why do we need it?

638

---

How can informatica be used for an organization?

651

---

How many types of sessions are there in informatica.please explain them?

678

---