1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

Question Posted / mahesh


is there any way to read the ms excel datas directly into informatica?like is there any possibilitie..

Answer / Sarvesh Umar Sahu

Yes, Informatica can read MS Excel data directly. You can use a PowerCenter session to connect to the Excel file as a source or target. The Excel Connection type can be found under 'File' in the Connection Types.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

State the differences between sql override and lookup override?

1 Answers  

Define Pmrep command?

1 Answers  

What is data merging,data cleansing,sampling?

4 Answers  

What are the different components of powercenter?

1 Answers  

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1 Answers  

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

What is a stored procedure transformation?

1 Answers  

How might one distinguish in the case of mapping is right or not without associating session?

1 Answers  

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

What is A cache?

2 Answers  

Why we need XMLs?

3 Answers   IBM,

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

For more Informatica Interview Questions Click Here
Categories