Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 23283

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 8203

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 26140

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

Infotech,

3 7916

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

IBM, Infotech,

4 35938

Why we need XMLs?

IBM,

3 7674

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

CTS,

5 45662

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

CTS,

2 8983

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 22690

How many mapplets u have created? and what is the logic used

Mind Tree,

5 11723

why do we go for update strategy tr in SCD rather using the session properties?

IBM,

3 16842

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 28916

How/where can i install Informatica software with oracle or teradata as database

2389

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 4910

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

TCS,

9 14134

Post New Informatica Questions

Un-Answered Questions { Informatica }

Why filter transformation is an active one?

931

What is the difference between informatics 7x and 8x and what is latest version?

1026

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1039

Briefly describe lookup transformation?

982

What is dimensional table? Explain the different dimensions.

1113

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 .

1888

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1606

what is unit testing?tell me proceedure

2168

Tell me about Propagate functions in informatica

878

Suppose we do not group by on any ports of the aggregator what will be the output?

986

Which transformation is needed while using the Cobol sources as source definitions?

1128

Explain sessions and how many types of sessions are there?

957

What do you mean by worklet?

1018

What do you mean by blocking transformation?

972

While migrating the data from one environment to another environment how would you manage the connections?

1048

For More Un-Answered { Informatica } Questions Click Here