Informatica Interview Questions
Questions Answers Views Company eMail

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

L&T,

18 30293

What is a candidate key?

CTS,

7 13792

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

Accenture, VAMA,

5 9020

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 5326

How can i set break points in debugging mode ? can explain steps please?

ABC, TCS,

1 13495

SO many times i saw "$PM parser error " .what is meant by PM?

1 7747

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1563

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

Magna Infotech,

4 8985

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 4842

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 5954

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 19899

How can we get multiple output values using an unconnected lookup transformation?

TCS,

2 15395

Is informatica power center designer has 64 bit support?

1 5187

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

TCS,

2 6567

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 7170


Post New Informatica Questions

Un-Answered Questions { Informatica }

Global and Local shortcuts. Advantages.

1438


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1649


Briefly describe lookup transformation?

580


What is data transformation manager process?

601


How do you convert single row from source into three rows into target?

579






Write the advantages of partitioning a session?

729


generate date / time dimension in informatica

696


How to call shell scripts from informatica?

547


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.

1821


What is an unconnected transformation?

640


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1629


What is an expression transformation in informatica?

493


Explain why we use partitioning the session in informatica?

589


What are the differences between a connected lookup and unconnected lookup?

624


Differentiate between sessions and batches?

545