Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / guest

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

More Informatica Interview Questions

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

Without using any transformations how u can load the data into target?

15 Answers   IBM,

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

Define Incremental Aggregation?

2 Answers  

Where do you create/define mapping parameter and mapping variable?

1 Answers  

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

What is resilience time?

0 Answers  

how to declare array in plsql?

1 Answers  

What is Datadriven?

2 Answers   Informatica,

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories