Informatica Interview Questions
Questions Answers Views Company eMail

Plz..let me know differences between Informatica 7.1 and 8.1?

3 10245

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 7551

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

Tech Mahindra,

7 14359

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

TCS,

6 12917

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

Deloitte,

10 32679

what are the differences between powercenter 8.1 and powercenter 8.5?

2 8446

wht is full process of Information source to target just like stg to productuon and development

Informatica,

1 6323

how to work with mapplet designer in informatica?

7 22313

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

Deloitte,

7 23221

How to generate the HTML output using Informatica.

Wipro,

3 10860

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 9296

wt is Dynamic lookup Transformation? when we use?how we use?

TCS,

2 24443

.prm wirh repalce .txt is possible?

2 6977

how tokens will generate?

1722

what transformations are used for Variable port?

2 19783


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the different versions of informatica?

670


What are ETL Tools?

654


What is a node in Informatica?

615


What is an aggregator transformation?

607


Write the program through which the records can be updated?

505






How many dimensions are there in informatica?

619


What's the layout of parameter file (what does a parameter file contain?)?

1909


Write the unconnected lookup syntax and how to return more than one column.

589


Enlist the differences between database and data warehouse.

536


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

797


Describe the impact of several join conditions and join order in a joiner transformation?

632


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1841


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8515


How to generate sequence numbers?

608


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1613