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

i have ten flat files with same structure,if
i want to load it to single target,and mapping needs to
should show only one source.what will be the steps to taken
to achieve it?/

Question Posted / prasuna

Answers were Sorted based on User's Feedback



i have ten flat files with same structure,if i want to load it to single target,and mapping needs ..

Answer / anoymous

Create a file system with extension .txt in that copy all
the 10 flat file paths.

Now at session level
source type : indirect
File directory : File system path
source file name: Name of file system.txt

Is This Answer Correct ?    16 Yes 0 No

i have ten flat files with same structure,if i want to load it to single target,and mapping needs ..

Answer / venkat

Create one parameter file and give all 10 flat files paths
in paramer file and use this parameter file in session
properties giving parameter file path and target should be
indirect than load in to target with single source.

Is This Answer Correct ?    10 Yes 0 No

i have ten flat files with same structure,if i want to load it to single target,and mapping needs ..

Answer / siva

using file Repository. source type :indirect

Is This Answer Correct ?    6 Yes 1 No

i have ten flat files with same structure,if i want to load it to single target,and mapping needs ..

Answer / arnab

Concat all the files using a Unix shell script to create a
new file and use this as the source file

If you use windows create a dos batch script

Then call the Unix shell script before calling the session
in the workflow , so that the process is automated

Is This Answer Correct ?    0 Yes 0 No

i have ten flat files with same structure,if i want to load it to single target,and mapping needs ..

Answer / prasuna

Hi shiva,thanks for giving answer..can u elaborate the
answer??

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is flashback table ? Advance thanks

0 Answers   Puma,

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

explain about session partitions ?

1 Answers  

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

Define Incremental Aggregation?

2 Answers  

Explain lookup transformation source types in informatica

0 Answers   Informatica,

What does refresh system mean, and what are its distinctive choice?

0 Answers  

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

What is data movement mode in Informatica and difference between them?

0 Answers  

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

For more Informatica Interview Questions Click Here
Categories