I want to copy the data into one excel file, while the mapping has been running in informatica.
I used Informatica last year, now am on SSIS. If I remember correctly, you can setup a separate connection for Excel target destination. There after you pretty much drag all fields from your source to the target destination (in this case Excel).
Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?
I have to load the target table copy of data into the text file at the time of workflow running.(i.e)Whatever data are going into the the target table that should come into the text file also.
Please help me to read data from a password protected excel file with informatica
Basically i need to convert excel to csv and read with informatica
Thanks
Suppose if we have duplicate records in a table temp_n. Now I want to pass unique values to t1 and duplicate values to t2 in single mapping? How can we achieve?