Answer Posted / ramesh

target1
SQ->Router->
target2

1.In router create one group and specity
the condition empid=201 or empid=202.
2.It is connected to target1.
3.Default group is connected to target2.

Thanks & Regards
Ramesh

Explain lookup transformation in informatica

1008

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1022

---

Explain sessions. Explain how batches are used to combine executions?

955

---

Explain what is informatica metadata and where is it stored?

989

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1230

---

Suppose we do not group by on any ports of the aggregator what will be the output?

986

---

To import the flat file definition into the designer where should the flat file be placed?

1008

---

is it possible to index the data in cache of lkp transformation ?

1961

---

list out all the transformations which use cache?

1115

---

Explain the etl program with few examples.

968

---

What is the use of an aggregator cache file?

1144

---

What are the different clients of powercenter?

1007

---

How we can create indexes after completing the loan process?

1146

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1591

---

What is the use of transformation?

948

---