how can we load 365 flat file to a single fact table
(target) as a history load in single mapping?
- 2 Answers
- 7547 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 |
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Differentiate between sessions and batches?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
how to create user defined function (udf) in informatica
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
How to load time dimension?
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Teradata 
