Answer Posted / babu

Hi A.C Sekhar,
If u r source is flat file,u should take seq/tr and agg/tr
in that take first function and last function after that
take a filter/tr filter condition is seqno !=fno or seqno!
=lno.

MAPPING;

SEQ-->SEQ-->AGG-->FLT-->TRG

PORTS;
NEXTVALUE -->SNO (SEQTR-->AGG)

IN AGG/TR
1.FNO=FIRST(SNO) OUTPUT PORT.
2.LNO=LAST(SNO) OUTPUT PORT.

IF ANY THING WRONG,PLEASE LET CORRECT ME.

THANKS,
BABU.

How to extract sap data using informatica? What is abap? What are idocs?

1253

---

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?

1168

---

What is informatica worklet?

1116

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2059

---

What is status code in informatica?

1065

---

How to do unit testing in informatica? How to load data in informatica ?

1187

---

draw informatica architecture 8.6 ?

3932

---

What is sequence generator transformation in informatica?

1127

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2128

---

How might one distinguish in the case of mapping is right or not without associating session?

1197

---

Please let me know how to make encryption and decryption with example?

1950

---

What does command task mean?

1217

---

What are the modules in Power Center

1720

---

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

1052

---

What is depict expression change?

1197

---