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

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

What are the rank caches?

2 Answers   Informatica,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  




what is fact table?

9 Answers  

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

How to update records in Target, without using Update Strategy?

3 Answers  

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

For more Informatica Interview Questions Click Here
Categories