Answer Posted / 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!!!!!!!!!!!!!!!!!

How to open an older version of an object in the workspace?

1126

---

What is a mapplet/worklet in informatica?

1120

---

What is dimensional table?

1002

---

Mention few power centre client applications with their basic purpose?

891

---

How to start a workflow using pmcmd command?

1174

---

What are the different options available for update strategy?

938

---

what is the complex transformation you used in informatica

2524

---

What is informatica?

1077

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2235

---

where to store informatica rejected data? How to extract the informatica rejected data?

955

---

What is a shortcut and copy in Informatica and how two are different with each other?

1130

---

What is the need of an ETL tool?

1027

---

Can we get 1st record through Informatica(without sequence number).

1406

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2179

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1026

---