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;

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2018

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1088

---

What is target designer and target load order?

1067

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1027

---

can we override a native sql query within informatica? Where do we do it?

1082

---

Explain what are the different versions of informatica?

1058

---

Explain the different kinds of facts.

948

---

how tokens will generate?

2172

---

Explian the Process of deployment groups in informatica

1014

---

Do you find any difficulty while working with flat files as source and target?

1066

---

How can we delete duplicate rows from flat files?

1181

---

Enterprise data warehouse your projects phase by phase explain?

1876

---

Name the different lookup cache(s)?

1174

---

What is sorter transformation?

999

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8183

---