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

1209

Explain what is informatica metadata and where is it stored?

1052

How can a transformation be made reusable?

1173

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2863

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

2402

What is deployment group?

1220

what is diff b/t sorter t/r and agg have the option sorter property...

2183

How can we improve session performance in aggregator transformation?

1123

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

1112

As union transformation gives UNION ALL output, how you will get the UNION output?

1110

What are the differences between oltp and olap?

976

What are active transformations.

1659

How does a rank transform differ from aggregator transform functions max and min?

1213

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1093

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1015