how can we load 365 flat file to a single fact table
(target) as a history load in single mapping?
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
Which files are created during the session rums by informatics server?
What do you understand by SOA of Informatica?
Differentiate between router and filter transformation?
How do you load first and last records into target table?
where to store informatica rejected data? How to extract the informatica rejected data?
what is size of u r database?
What do mean by local and global repository?
What are the advantages of informatica?
How do you promote a non-reusable transformation to reusable transformation?
What is the sequence generator transformation in informatica?
What is decode in informatica?
Which version configuration tool used in ur project?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is meant by incremental aggregation?
What is the difference between writing a joiner query in ANSI style and THETA style?