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 30944

What is a candidate key?

CTS,

7 14055

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 9235

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 5509

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

ABC, TCS,

1 13604

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

1 7855

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

1621

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 9264

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 4986

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 6099

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

2 20086

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

TCS,

2 15553

Is informatica power center designer has 64 bit support?

1 5296

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

TCS,

2 6702

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 7417


Post New Informatica Questions

Un-Answered Questions { Informatica }

How can repository reports be accessed without sql or other transformations?

763


What is a joiner transformation?

604


Enlist the advantages of informatica.

669


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

632


Explain joiner transformation in informatica

699






I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1660


Explain the different dimensions.

585


How can you validate all mappings in the repository simultaneously?

798


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5335


explan ur project architecture?

1635


How to join three sources using joiner?

612


What does role playing dimension mean?

667


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1962


Explain scd type 3 through mapping.

621


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

661