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
- 8383 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
How do you set a varible in incremental aggregation
Explain in detail scd type 2 through mapping.
Could you explain what is enterprise data warehouse?
What is union transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to delete duplicate row using informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
In informatica workflow manager, how many repositories can be created?
How do we call shell scripts from informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is unit testing?tell me proceedure
What are the different types of repositories created using informatica?
What is olap (on-line analytical processing?
What is the difference between source qualifier transformations source filter to filter transformation?
