Informatica Interview Questions
Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

577

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

587

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

518

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

692

How do you remove duplicate records in informatica?

1 684

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

1272

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

649

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.

754

Explain in detail scd type 2 through mapping.

596

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

692

Explain the different kinds of facts.

549

How do you load only null records into target?

722

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

600

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

572

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

676


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a filter transformation?

553


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1919


Explain lookup transformation is active in informatica

648


where to store informatica rejected data? How to extract the informatica rejected data?

587


can anyone explain me about retail domain project in informatica?

7411






Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

535


Difference between Data and Index Caches?

639


What is InformaticaPowerCenter?

675


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5738


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 .

1455


EXL informatica Questions

916


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?

1029


What is the use of an aggregator cache file?

671


what is informatica metadata?

585


How to extract sap data using informatica? What is abap? What are idocs?

540