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
- 8429 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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the different ways to implement parallel processing in informatica?
What are the differences between source qualifier and joiner transformation?
r u done any partitions in ur project?
what is song in infrmatica...?
How we can create indexes after completing the loan process?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is rank transformation?
Which files are created during the session rums by informatics server?
How to load data in informatica ?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to start a workflow using pmcmd command?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to update source definition?
