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.

What are the various types of transformation?

1156

---

What is a joiner transformation?

965

---

Separate from a database, an information bazaar, and an information stockroom?

1070

---

What are the differences between source qualifier and joiner transformation?

1033

---

What the difference is between a database, a data warehouse and a data mart?

1137

---

How can you define user defied event?

1008

---

Did u used latest transformations of 8.6.0? for what?

1868

---

What is rank transform?

978

---

Is it possible to define a single node as a Gateway node as well as worker node?

1103

---

what are the Methods For Creating Reusable Transformations?

1151

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4093

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1057

---

Where can we find the throughput option in informatica?

1042

---

How to create the source and target database connections in server manager?

1071

---

How many dimensions are there in informatica?

1065

---