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
- 8547 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 |
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
Explain the different dimensions.
Explain factlessfact table with scenario
What all are steps in up gradation of Informatica server?
What are the new features of the server manager in the informatica 5.0?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
what is the difference between Informatica 7.1 and Abinitio?
what is Active lock explain
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
write a query to retrieve the latest records from the table sorted by version(scd)
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
How to delete the (flat file) data in the target table after loaded.
Teradata 
