Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 27329

What is a candidate key?

CTS,

7 12777

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 8131

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 4591

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

ABC, TCS,

1 12784

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

1 7332

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

1364

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 8185

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 4391

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 5299

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

2 19161

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

TCS,

2 14565

Is informatica power center designer has 64 bit support?

1 4743

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

TCS,

2 5932

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 6166


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is powercenter on grid?

397


What do you understand by term role-playing dimension?

365


What is lookup change?

402


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1491


What is a dimensional model?

380






What is enterprise data warehousing?

388


How do you handle two sessions in Informatica

426


What is mapping debugger?

380


Name the different lookup cache(s)?

389


Have you worked with/created Parameter file

1037


Is there any target staging area in informatica not staging area

1877


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1370


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

385


How many numbers of sessions can one group in batches?

405


What is resilience time?

440