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

Differentiate between reusable transformation and mapplet.

0 Answers  


What is the Difference between DSS & OLTP?

5 Answers  


On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  


What is a filter transformation and why it is an active one?

0 Answers  


what is junk dimension

4 Answers   Cap Gemini,






we have to use order by,where,having we to implement sql query

1 Answers   Satyam,


Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,


WAT IS TEXT LOAD?

3 Answers   Wipro,


What is hash partition?

1 Answers  


How to do Integration testing in Informatica?

5 Answers   Intelligroup,


What are active transformations.

0 Answers  


How can you increase the performance in joiner transformation?

0 Answers  


Categories