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
- 8388 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
Whats there in global repository
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the difference between stop and abort in informatica
What do you mean by enterprise data warehousing?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
State the differences between sql override and lookup override?
How can you increase the performance in joiner transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Tell me about MD5 functions in informatica
Describe data concatenation?
What is the meaning of decode in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the various types of transformation?
