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.

Explain the use of aggregator cache file?

1253

---

How to extract sap data using informatica?

1042

---

how tokens will generate?

2204

---

Quickly characterize reusable change?

1119

---

Explain what is informatica metadata and where is it stored?

1049

---

How might one distinguish in the case of mapping is right or not without associating session?

1119

---

what is Active lock explain

2799

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2072

---

Briefly explain the aggregator transformation?

1008

---

What is a snowflake schema?

994

---

Different circumstance which drives informatica server to expel records?

983

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305

---

What is confirmed fact in dataware housing?

6967

---

What are the tuning techniques you applied during your last project

2024

---

How do you take back up of repository?

1160

---