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 advantages of informatica?

1014

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2132

---

Why do you use Mapping Parameter and mapping variable?

1766

---

What is meant by lookup transformation?

1110

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2264

---

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?

1086

---

What is the meaning of up gradation of repository?

1992

---

where to store informatica rejected data?

1093

---

What are the main issues while working with flat files as source and as targets ?

1163

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10687

---

How can you define user defied event?

1031

---

What is depict expression change?

1121

---

What is aggregate cache in aggregator transformation?

1145

---

How to improve the performance of a session using sorter transformation?

1147

---

What is data movement mode in Informatica and difference between them?

1138

---