Answer Posted / jvdwhinfo

Write sql override in the source qualifier t/r.
select columns from
( select columns,rank() over(order by sal desc ) as
rank from emp)
where rank <=10;
let me know if any corrections.

Thanks.
James

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7267

---

In informatica workflow manager, how many repositories can be created?

1271

---

What are the different components of powercenter?

986

---

Different circumstance which drives informatica server to expel records?

918

---

Target increases every day even though no new record was inserted

1516

---

What is the use of an aggregator cache file?

1144

---

What are the differences between joiner transformation and source qualifier transformation?

1099

---

What is a mapplet/worklet in informatica?

1126

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1909

---

What is informatica powercenter repository?

1143

---

What is an aggregator transformation?

1032

---

Enterprise data warehouse your projects phase by phase explain?

1856

---

what are the Methods For Creating Reusable Transformations?

1102

---

What is a filter transformation?

990

---

update strategy transformation in informatica

1017

---