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

Describe expression transformation?

0 Answers  

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

What is workflow manager?

0 Answers  

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

Whats there in global repository

0 Answers  

what is casual dimension?

6 Answers   IBM,

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  

Differentiate between reusable transformation and mapplet.

0 Answers  

For more Informatica Interview Questions Click Here
Categories