Interested to Buy Any Domain ? << Click Here >> for more details...
how can we load 365 flat file to a single fact table
(target) as a history load in single mapping?
- 2 Answers
- 8502 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravi
Above answer given by Nagaraju works fine.
We need to goto workflow,open Task properties
Goto mappings Tab, then go to source properties. Change
source file type attribute to 'indirect' and give source
file name attribute value to file name that contains list
flat files to be loaded(complete path).
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you remove duplicate records in informatica? And how many ways are there to do it?
Explain joiner transformation in informatica
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Different circumstance which drives informatica server to expel records?
What is the need for an etl tool?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain sessions?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is informatica metadata and where is it stored?
Where are the source flat files kept before running the session?
What is target load order?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is a transaction control transformation?
On which transformations you created partitions in your project?
What are the new features of Power Center 5.0?
