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
State the limitations where we cannot use joiner in the mapping pipeline?
what is mean by complex business rule ?
How to generate sequence numbers?
How do you use reject loader.
What is rank transformation?
In informatics server which files are created during the session rums?
What is event and what are the tasks related to it?
How can we delete duplicate rows from flat files?
What is domain in terms of informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is expression transformation?
Plz can any one say me how to get the informatica certification materials and dumps
What is the difference between source qualifier transformations source filter to filter transformation?
Explain dynamic target flat file name generation in informatica
How do you load unique records into one target table and duplicate records into a different target table?