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

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.

Answer / siva

using file Repository. source type :indirect

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

Answer / prasuna

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

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

what is casual dimension?

6 Answers   IBM,

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

tell me the rules and responsblites in our project(my project is development)

0 Answers  

What are different types of transformations available in informatica?

0 Answers  

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

What are the new features of informatica 7.1?

2 Answers  

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

What is synonym?

2 Answers   Patni,

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,