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?

256

What do you mean by channel change?

223

What are the measure objects?

297

What are the different types of transformation available in informatica.

250

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

223

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

239

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

230

Explain the different dimensions.

213

Differentiate between source qualifier and filter transformation?

292

Explain scd type 3 through mapping.

248

What is dimensional table?

245

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

430

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

225

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.

234

Explain in detail about scd type 1 through mapping.

224


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is the function of look up transformation?

255


How union transformation is used?

235


In warehouses how many schemas are there?

251


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1174


What the difference is between a database, a data warehouse and a data mart?

234






Differentiate between joiner and lookup transformation?

244


Enlist the tasks for which source qualifier transformation is used.

240


How do you take back up of repository?

291


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

265


What if the source is a flat-file?

240


Mention a few design and development best practices for informatica?

238


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1079


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

5177


Quickly characterize reusable change?

256


How to create a non-reusable instance of reusable transformations?

280