Informatica Interview Questions
Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

589

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

596

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

523

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

698

How do you remove duplicate records in informatica?

1 708

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

1281

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

655

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.

763

Explain in detail scd type 2 through mapping.

607

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

695

Explain the different kinds of facts.

555

How do you load only null records into target?

732

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

608

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

575

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

686


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the use of transformation?

565


What is the cumulative sum and moving sum?

746


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1830


explain about unit testing? in real time?

1650


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1688






How to update a particular record in target with out running whole workflow?

1149


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1041


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

626


Enlist the various types of transformations.

547


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

1583


tell me the rules and responsblites in our project(my project is development)

1491


Which files are created during the session rums by informatics server?

700


how to load rows into fact table in data warehouse

634


What is a grid in Informatica?

604


How to partition the Session?

638