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
- 8542 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagaraju bhatraju
if your flat file are of same structure then analyze any
one of the file in sourceanalyzer of informatica,and
proceed with mapping development, hence you will have only
one mapping, but make all other flat file entries into
other file along with their exact path of files and save
this indexfile or file with all files entires with .dat.
and give this file name in source file directory or source
file and change load type from direct to indirect, hence
all the 365 files will be loaded in to the singe target ,
with single mapping , this concept will be called as file
list or file repository .
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
define galaxy repository in informatica
How to do unit testing in informatica? How to load data in informatica ?
What the difference is between a database, a data warehouse and a data mart?
What is the need of an ETL tool?
Explain constraint based loading in informatica
Define the various join types of joiner transformation?
How can you differentiate between powercenter and power map?
How do you handle two sessions in Informatica
What is difference between a gateway node and worker node?
What is a surrogate key?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to go to the older version for a mapping?
Define enterprise data warehousing?
What differs when we choose the sorted input for aggregator transformation?
Explain pushdown optimization and types in informatica
