Answer Posted / sweta kedia

Select EMPID from EMPSAL Where MONTHYEAR IN(SELECT monthyear
from empsal
Group By monthyear
where
sal> 100000)

What are junk dimensions?

1114

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2057

---

what is index?how it can work in informatica

2084

---

Explain constraint based loading in informatica

1157

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1859

---

Explain transaction control transformation in informatica

1312

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1022

---

whats the logic to load the lower level of granularity of data to fact table.

2312

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1965

---

Explain what are the different versions of informatica?

1146

---

How to create or import flat file definition in to the warehouse designer?

1135

---

Explain the scenario which compels informatica server to reject files?

1210

---

Explain the use of aggregator cache file?

1319

---

What is union transformation in informatica?

1192

---