Answer / ashok nidamanuri

We can implement like this
1)Take sequence genarator transformation and get sequence
of no's for each and every record
2)Then in expression take two output port's like out_min
and out_max.Assign Min and Max functions to corrsponding
output ports then u will get Min and max value of the
records
3)Take filter transformaton and filter those two records in
filter tarnsformation.

try with this!!!!!!!!!!!!!!!!!!!

Answer / purushothaman

put one expression after the source qualifer
and type this code

for example take this record
HDR20008
....
TRL2000800020

output variable name = IFF(SUBSTR(columnname ,1,3)
='HDR','Y','N')
Similarly put for trailer record condition in the
expression

after this expression put the one filter like this
output variable name ='Y'


cheers!!!!!!!!!!!!!!!!!

What is active and passive transformation?

10 Answers  

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

Explain how many types of dimensions are available in informatica?

0 Answers  

---

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

---

What are Target Options on the Servers?

1 Answers  

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

How to load a Dimension ? and how to load a fact table?

0 Answers  

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

what is confirmed fact?

2 Answers  

---