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

Informatica Interview Questions

Questions Answers Views Company eMail

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 3306

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2066

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

TCS,

1 3788

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

TCS,

2 4306

explain different levels in pushdown optimization with example?

TCS,

2 7292

waht type of interface is used for testing the data in informatica

CTS, TCS,

2256

wat are deployement groups in informatica, how it will be used for developers

1719

what is the difference between informatica6.1 and infomatica7.1

TCS,

2276

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9035

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

CTS,

3 8951

how to through logic of informatica using the push down optimization into oracle.

Hexaware,

2 7778

Is there any model difference between ODS and DWH

Zensar,

2 7342

How You Pull the records on daily basis into your ETL Server.

TCS,

2 7104

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

Mphasis,

2 15070

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

Zensar,

2 6770

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are Dimensional table?

1055

How to differentiate between the active and passive transformations?

1166

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

1933

How does the aggregator transformation handle null values?

1149

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091

Differentiate between sessions and batches?

1018

Explain the difference between a data warehouse and a data mart?

1056

How do you promote a non-reusable transformation to reusable transformation?

1138

How we can use union transformation?

1051

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

1122

Explain about cumulative Sum or moving sum?

1043

What is the difference between a repository server and a powerhouse?

1513

What the difference is between a database, a data warehouse and a data mart?

1155

What is source qualifier transformation in informatica?

1011

What is a sorter transformation?

1102

For More Un-Answered { Informatica } Questions Click Here