Informatica Interview Questions
Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

633

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

648

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

566

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

754

How do you remove duplicate records in informatica?

1 782

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

1346

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

708

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.

820

Explain in detail scd type 2 through mapping.

657

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

756

Explain the different kinds of facts.

594

How do you load only null records into target?

782

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

645

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

613

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

733


Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the informatica workflow?

630


where to store informatica rejected data?

720


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1672


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 .

1502


Under what conditions selecting sorted input in aggregator will still not boost session performance?

668






Define Pmrep command?

672


Name at least 5 different types of transformations used in mapping design and state the use of each.?

718


What is a code page?

753


State the limitations where we cannot use joiner in the mapping pipeline?

583


Can we create a node as a gateway node and the same node can be assigned to a grid?

667


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

633


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

1197


What is the difference between router and filter?

678


How to go to the older version for a mapping?

650


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.

1662