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

Quickly characterize reusable change?

422

What do you mean by channel change?

342

What are the measure objects?

428

What are the different types of transformation available in informatica.

407

Explain what are the different types of transformation available in informatica.

347

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

378

How to do unit testing in informatica? How to load data in informatica ?

397

Explain the different dimensions.

333

Differentiate between source qualifier and filter transformation?

630

Explain scd type 3 through mapping.

369

What is dimensional table?

402

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

611

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

362

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

368

Explain in detail about scd type 1 through mapping.

366


Post New Informatica Questions

Un-Answered Questions { Informatica }

Why filter transformation is an active one?

365


Define sessions in informatica etl?

424


What are the different ways to implement parallel processing in informatica?

566


How can we use mapping variables in informatica? Where do we use them?

373


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1249






Where can we find the throughput option in informatica?

399


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

999


How identifying bottlenecks in various components of informatica and resolving them?

364


whats the logic to load the lower level of granularity of data to fact table.

1517


Under what condition selecting sorted input in aggregator may fail the session?

447


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

392


What is the difference between a connected look up and unconnected lookup?

356


Explain the features of connected and unconnected lookup.

334


How to open an older version of an object in the workspace?

424


Explain what are the different versions of informatica?

402