how to insert header after each group.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are roles and groups and benefits of using them?

569


What are the tuning techniques you applied during your last project

1567


Explain the tuning lookup transformation - informatica

615


What is a passive transformation?

646


Enlist the advantages of informatica.

632






How we can use union transformation?

612


Briefly describe lookup transformation?

601


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1466


Can we create multiple integration service on single repository?

705


In how many ways we can create ports?

703


have u done any performance tuning? how u ll do?

1861


What is update strategy transform?

580


Describe data concatenation?

576


What is a mapplet/worklet in informatica?

692


What is the Rank index port in Rank transformation?

672