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
- 8544 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
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the scenario which compels informatica server to reject files?
How can we delete duplicate rows from flat files?
What is sq transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the cumulative sum and moving sum?
list out all the transformations which use cache?
What is Cognos script editor?
How might one distinguish in the case of mapping is right or not without associating session?
What are the new features of Power Center 5.0?
difference between informatica 8.1.1 and 8.6
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is an aggregator transformation?
