I am doing flat file data uploading into the InfoCube. One InfoObject is that of the TICKET_ID. I have another InfoObject
which counts the number of tickets ie. for each unique Ticket ID the count of ticket should be equal to one.
However in the flat file the TICKET_ID repeats multiple number of times. I want to write a routine in the transformation which maps the TICKET_ID to the number of tickets. For each of the unique ticket ID the Number of Ticket should be equal to one. For the TICKET_ID's repeating the number of ticket should be equal to one.
Can you please help me out with the routine.
Thanks in advance.