Answer Posted / kalyan

we have the lOOKUP OVERRIDE Query in the Lookup
transformation. Use the SQl Query to join the tables you
lookup on. Thsi is similar to what yo do at the Source
Qualifier

How do you manage the Parameter files while migrating your data from one environment to another environment?

963

---

I have a flat file, want to reverse the contents of the flat file

1064

---

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

981

---

COM components can be used in Informatica

2312

---

What is sq transformation?

1079

---

Explain the shared cache and re-cache?

1048

---

How do you promote a non-reusable transformation to reusable transformation?

1067

---

Implementation methodology

1653

---

Define the various join types of joiner transformation?

940

---

What is persistent lookup cache?

965

---

wat are deployement groups in informatica, how it will be used for developers

1667

---

Write the prerequisite tasks to achieve the session partition?

1071

---

Where do we use mapping variables in informatica?

996

---

Could you explain what is enterprise data warehouse?

1046

---

what is diff b/t sorter t/r and agg have the option sorter property...

2128

---