how to insert header after each group.



how to insert header after each group...

Answer / rohit

I have below records.

EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-

101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,


What is decode in static cache?

0 Answers  


Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,


How will you update the row without using update statergy?

10 Answers   CTS,






My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,


Did u used latest transformations of 8.6.0? for what?

0 Answers  


How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  


what is filelist concept in informatica

4 Answers  


Name the different lookup cache(s)?

0 Answers  


How to delete the data in the target table after loaded.

3 Answers   TCS,


hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  


Categories