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

Informatica Interview Questions

Questions Answers Views Company eMail

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 2771

Have you worked with/created Parameter file

1667

What's the layout of parameter file (what does a parameter file contain?)?

Cognizant,

2388

Why do you use Mapping Parameter and mapping variable?

1770

Where do you create/define mapping parameter and mapping variable?

1 3337

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

IBM,

1 3699

Slowly changing dimensions, types and where will you use them

1717

What are the modules in Power Center

1681

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 5376

Parameter and variable differences

2063

Reusable transformation and shortcut differences

1842

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 2536

Implementation methodology

1716

Do you have knowledge in ralph kimball methodology

1 3527

According to his methodology what all you need before you build a datawarehouse

1760

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1092

Does an informatica transformation support only aggregate expressions?

1043

What are mapplets?

1277

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

Briefly define a session task?

1138

Please let me know how to make encryption and decryption with example?

1905

Differences between connected and unconnected lookup?

1223

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1956

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2038

Can we override a native sql query within informatica?

1041

What is an active transformation?

1113

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

What is joiner transformation in informatica?

1046

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

1720

In development project what is the process to follow for an etl developer from day1

1724

For More Un-Answered { Informatica } Questions Click Here