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

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

How to call shell scripts from informatica?

0 Answers  

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

which one is better performance wise joiner or look up

0 Answers   Informatica,

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

Please let me know how to make encryption and decryption with example?

0 Answers  

How to generate sequence numbers?

0 Answers  

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

What is substr in informatica?

0 Answers  

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

Can you copy the batches?

3 Answers  

For more Informatica Interview Questions Click Here
Categories