Answer Posted / joe

We cannot use a sorter because it will shuffle the data.

For the last 20 rows. In a seperate pipeline use aggregator
and do a Count(key) and Max(key) to get the total number of
rows.
use an output port o_count and o_max to populate this count
to an expression transformation before the Filter.

o_count_last_20 = o_count - 20
i.e. if there are 35 records we need records from 15 to 35

In the filter check nextval between o_count_last_20 and
o_Max

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

1048

---

Define joiner transformation?

981

---

what is INFORMATICA TESTING process

2223

---

What do you mean by filter transformation?

900

---

what is unit testing?tell me proceedure

2163

---

Is it possible to revert a global repository to local one and why?

1021

---

How would you copy the content of one repository to another repository?

947

---

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2052

---

State the differences between sql override and lookup override?

1111

---

how to create user defined function (udf) in informatica

1237

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2137

---

What is intricate mapping?

1088

---

Differentiate between sessions and batches?

962

---

What are the components of Informatica? And what is the purpose of each?

980

---

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

7264

---