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
- 8546 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Normalizer transformation is not involved in Mapplet.. why???
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
HOW DO YOU CONNECT TO REMOTE SERVER ?
how the informatica server sorts the strings values in rank transformations?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
What is deployemnt groups, Lables, query and dynamic deployment group.
sample mappings for scd1,scd2 and scd3
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
Explain what is informatica metadata and where is it stored?
tell me 7.x and 8.x diferrencess(but not transformations)
Teradata 
