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 24790

What is a candidate key?

CTS,

7 11897

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 7326

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 4035

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

ABC, TCS,

1 11978

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

1 7039

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

1190

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 7575

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 4001

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 4803

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

2 18420

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

TCS,

2 13691

Is informatica power center designer has 64 bit support?

1 4484

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

TCS,

2 5319

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 5513


Post New Informatica Questions






Un-Answered Questions { Informatica }

How do you take back up of repository?

265


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1262


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

779


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

3961


what are factless facts? And in which scenario will you use such kinds of fact tables.

925






Explain the different kinds of facts.

203


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

208


Separate from a database, an information bazaar, and an information stockroom?

228


What is a grid in Informatica?

248


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

233


How many ways a relational source definition can be updated and what are they?

220


What is meant by lookup transformation?

233


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1105


Define mapplet?

229


How to call shell scripts from informatica?

220