Answer Posted / koti

Re: How do you create single lookup transformation using
multiple tables?
Answer
# 1 Lookup transformation: Based upon one/more keys the
data is
retreived from one/more tables.

create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1173

---

How to load a Dimension ? and how to load a fact table?

941

---

Explain pmcmd command usage in informatica

693

---

What is a joiner transformation and why it is an active one?

566

---

What is session task and command task?

637

---

---

what are 3 tech challenges/ common issues you face?

1875

---

Different qualification between a related rotate toward the sky and isolates look upward?

543

---

Explain sessions?

594

---

What is target load order?

795

---

Can we override a native sql query within informatica?

620

---

What is the need of an ETL tool?

631

---

What is the benefit of session partitioning?

584

---

Repository user profiles

1368

---

Can you generate sequence numbers without using the sequence generator transformation?

591

---

What is an unconnected transformation?

654

---