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.

2065

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 3783

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

TCS,

2 4305

explain different levels in pushdown optimization with example?

TCS,

2 7291

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,

2275

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9033

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

CTS,

3 8949

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

Hexaware,

2 7775

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 7101

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 }

Explain how many types of dimensions are available in informatica?

1098

What is meant by active and passive transformation?

1125

Describe the impact of several join conditions and join order in a joiner transformation?

1062

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

How can you increase the performance in joiner transformation?

1190

what is the complex transformation you used in informatica

2587

Why union transformation is an active transformation?

1047

Explain joiner transformation in informatica

1124

How to join three sources using joiner?

1114

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

1124

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032

Differentiate between Load Manager and DTM?

2153

What do you understand by term role-playing dimension?

1048

For More Un-Answered { Informatica } Questions Click Here