Answer Posted / kamlesh mishra

The PowerCenter Server skips the specified number of rows
before reading the file. Use this to skip header
rows in the file.
And for last rows implement following logic.

1) Take sorter transformation reverse the rows on the basis of some key field like empno.
2)take expr transformation add nextval from sequence generator
3) Take filter transformation add condition nextval !=1 .
4)(optional)reverse the rows again using sorter transformation.
5) From filter to tgt connect the respective ports.

Src---->SQ--->SORTER--->EXPR---->FILTER---->SORTER---->TGT

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2688

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2180

---

How do you use reject loader.

2542

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1891

---

What are junk dimensions?

1019

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1046

---

What is meant by active and passive transformation?

1027

---

What does reusable transformation mean?

1066

---

What is parallel processing in informatica?

1616

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6037

---

what is the complex transformation you used in informatica

2521

---

Where do we use mapping variables in informatica?

995

---

In informatics server which files are created during the session rums?

1060

---

What is status code in informatica?

959

---

What are the new features of informatica 9.x in developer level?

936

---