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

How to load last n records of file into target table - informatica

0 Answers   Informatica,

What is polling?

1 Answers  

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

waht is dataware house

2 Answers  

What is a test load?

1 Answers  




what are the transformations that restricts the partitioning of sessions?

1 Answers  

what is degenerated dimension

6 Answers   Cap Gemini,

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

For more Informatica Interview Questions Click Here
Categories