What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

Where is metadata stored?

0 Answers  

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

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

0 Answers  

---

How the facts will be loaded? explain

2 Answers   HCL,

---

why do u use shortcuts in informatica.?

4 Answers   iFlex,

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

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

0 Answers   Informatica,

---