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

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

explain about informatica server architecture?

1 Answers   IBM,

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

What are the types of presistent cache in look up tr.

0 Answers   IBM,

What is an aggregator transformation?

0 Answers  

Where do we use mapping variables in informatica?

0 Answers  

What is the use of code page?

0 Answers  

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

What is polling?

1 Answers  

For more Informatica Interview Questions Click Here
Categories