Answer Posted / amedela chandra sekhar

write sql query in the source qualifier t/r

sql override

select * from(select dense_rank () over (order by sal desc
nulls last)as rnk,emp.* from emp)where rnk<=10;

what is the Default Source Option For Update Strategy Transformation?

1241

---

Different sorts of metadata that stores in the storage facility?

1013

---

What is the use of target designer?

1055

---

What is domain in terms of informatica?

1008

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5794

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1080

---

What is sorter transformation?

1048

---

what are 3 tech challenges/ common issues you face?

2346

---

Explain dynamic target flat file name generation in informatica

1055

---

What is confirmed fact in dataware housing?

6970

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2169

---

What are the new features of informatica 9.x developer?

970

---

What is informatica etl tool?

1000

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1109

---

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

2276

---