top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to copy the data into one excel file at the time of mapping running in informatica?

0 votes
555 views

I want to copy the data into one excel file, while the mapping has been running in informatica.

posted May 26, 2014 by Pooja Bhanout

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Can you elaborate your requirement? Like what is your source, from which server you want to copy the data into an excel file.
commented Jun 11, 2014 by Shatark Bajpai

1 Answer

0 votes

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).

answer May 27, 2014 by Shweta Singh
Similar Questions
0 votes
Informatica: Mapping to Load the first record from a flat file into one table?

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?

+1 vote
How to copy the data loaded into target table from source table to the text file?

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.

+1 vote
How to read data from password protected excel file with informatica

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

0 votes
Informatica: How to pass unique values to one table and duplicate values to another one in a single mapping?

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?

...