how can we load 365 flat file to a single fact table
(target) as a history load in single mapping?
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 to Create a folder using pmrep command?
What are the data movement modes in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the difference between informatics 7x and 8x and what is latest version?
Make a note of the quantity vaults made in informatica?
How to update source definition?
What is a joiner transformation?
Global and Local shortcuts. Advantages.
Why is sorter an active transformation?
Explain constraint based loading in informatica
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Mention a few design and development best practices for informatica?
Define mapplet?
what is song in infrmatica...?