Data Warehousing Interview Questions

What is the difference between a connected look up and unconnected look up?

Informatica

Written by ideadeolo Monday, 16 January 2012 00:09

Connected lookup takes input values directly from other transformations in the pipleline.
Unconnected lookup doesnt take inputs directly from any other transformation, but it can be used in any transformation (like expression) and can be invoked as a function using :LKP expression. So, an unconnected lookup can be called multiple times in a mapping.

 

What are the types of data that passes between informatica server and stored procedure?

Informatica

Written by ideadeolo Monday, 16 January 2012 00:09

3 types of data
• Input/Out put parameters
• Return Values
• Status code.

What is the status code?

Informatica

Written by ideadeolo Monday, 16 January 2012 00:09

Status code provides error handling for the informatica server during the session. The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully.This value can not seen by the user. It only used by the informatica server to determine whether to continue running the session or stop.

 

What is source qualifier transformation?

Informatica

Written by ideadeolo Monday, 16 January 2012 00:09

When you add a relational or a flat file source definition to a mapping, you need to connect it to a source qualifier transformation. The source qualifier transformation represents the records that the informatica server reads when it runs a session.

What are the types of loading in Informatica?

Informatica

Written by hydromegastuffer Monday, 16 January 2012 00:07

There are two types of loading, normal loading and bulk loading. In normal loading, it loads record by record and writes log for that. It takes comparatively a longer time to load data to the target in normal loading. But in bulk loading, it loads number of records at a time to target database. It takes less time to load data to target.

 

Page 1 of 5

«StartPrev12345NextEnd»

Login Form (Can use your Gmail Acct)

Latest Comments

Copyright © 2017 Interview Questions, Tutorials, Certification Questions. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.