how can we load 365 flat file to a single fact table (target) as a history load

how can we load 365 flat file to a single fact table
(target) as a history load in single mapping?

Question Posted / guest

2 Answers
7580 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?..

Answer / 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

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?..

Answer / 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