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!!!!!!!!!!!!!!!!!

Where is metadata stored?

0 Answers  

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

what are the types of Data warehousing ?

1 Answers  

---

What is surrogate key?

9 Answers  

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

how will you get 21 to 30 record from 50 records?

6 Answers  

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

What do you mean by blocking transformation?

0 Answers  

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---