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

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

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

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

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

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?

...