Informatica Interview Questions
Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

594

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

600

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

526

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

703

How do you remove duplicate records in informatica?

1 711

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

1286

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

660

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.

767

Explain in detail scd type 2 through mapping.

609

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

703

Explain the different kinds of facts.

560

How do you load only null records into target?

738

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

610

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

583

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

693


Post New Informatica Questions

Un-Answered Questions { Informatica }

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1627


What does update strategy mean, and what are the different option of it?

584


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1769


Did u used latest transformations of 8.6.0? for what?

1473


What are the differences between source qualifier and joiner transformation?

594






EXL informatica Questions

929


What is enterprise data warehousing?

611


What is different between the data warehouse and data mart?

626


Why update strategy and union transformations are active?

589


What is the procedure for creating independent data marts from informatica 7.1?

560


can we override a native sql query within informatica? Where do we do it? How do we do it?

595


Enlist the tasks for which source qualifier transformation is used.

584


How you prepared reports for OLAP?

1149


How would you copy the content of one repository to another repository?

549


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1843