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 |
How to read data from flat file source if the data is in paragraph format?
What is decode in static cache?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
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?
How will you update the row without using update statergy?
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
Did u used latest transformations of 8.6.0? for what?
How to load the data from people soft hrm to people soft erm using informatica?
what is filelist concept in informatica
Name the different lookup cache(s)?
How to delete the data in the target table after loaded.
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