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

What are the differences between source qualifier and joiner transformation?

362

How do you convert single row from source into three rows into target?

350

What are the types of schemas we have in data warehouse.

328

Why update strategy and union transformations are active? Explain with examples.

405

How do you remove duplicate records in informatica?

1 366

How do you load alternate records into different tables through mapping flow?

474

How do you load first and last records into target table?

367

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

437

Explain in detail scd type 2 through mapping.

354

How do you load unique records into one target table and duplicate records into a different target table?

430

Explain the different kinds of facts.

357

How do you load only null records into target?

400

What is fact table? Explain the different kinds of facts.

399

How many ways are there to do 'remove duplicate records in informatica'?

358

How to join three sources using joiner? Explain though mapping flow.

419


Post New Informatica Questions

Un-Answered Questions { Informatica }

what is degenerated dimension?

2799


Why update strategy and union transformations are active? Explain with examples.

405


How can we use mapping variables in informatica?

367


What is enterprise data warehousing?

390


What are the settings that you use to configure the joiner transformation?

390






what is INFORMATICA TESTING process

1625


Describe expression transformation?

408


What is sq transformation?

385


How are indexes created after completing the load process?

710


Do you find any difficulty while working with flat files as source and target?

423


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1303


Explain the types of lookup transformation?

350


Explain the difference between a data warehouse and a data mart?

387


What are the differences between a connected lookup and unconnected lookup?

414


Explain sessions. Explain how batches are used to combine executions?

373