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 basic requirements to join two sources in a source qualifier transformation using default join?

609

---

What is lookup change?

614

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1123

---

Can anyone tell me the new features in Informatica 9 Version?

1527

---

What is data transformation manager process?

619

---

---

Explain what transformation and how many are there in informatica?

482

---

What is union transformation in informatica?

695

---

What is workflow? What are the components of the workflow manager?

633

---

what is unit testing?tell me proceedure

1772

---

To import the flat file definition into the designer where should the flat file be placed?

673

---

How do you handle two sessions in Informatica

657

---

How can you increase the performance in joiner transformation?

704

---

Tell me about MD5 functions in informatica

519

---

Mention some types of transformation?

602

---

What is the need of an ETL tool?

640

---