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 |
Explain Dataware house architecture .how data flow from intial to end?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
What is the use of code page?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the mapings that we use for slowly changing dimension table?
Which kind of index is preferred in DWH?
How to load last 10 records of flat file in to the target?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
Normalizer transformation is not involved in Mapplet.. why???
What is power play plug in?
What is degenerated dimention table?