31. How do you call a store procedure within a transformation?
In the expression transformation create new out port in the expression write :sp.stored procedure name (arguments).
32. What is difference between Informatica power mart and power center?
Sequential(Run the sessions one by one
Concurrent (Run the sessions simultaneously)
34. What is main difference mapplets and mapping?
Reuse the transformation in several mappings, where as mapping not like that.
If any changes made in mapplets it automatically inherited in all other instance mapplets.
35. Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank
transformation will output?
5 Rank.
36. What is bitmap index?
A bitmap for each key value replaces a list of rowids. Bitmap index more efficient for data warehousing
because low cardinality, low updates, very efficient for where class.
37. Why need staging area database for DWH?
Staging area needs to clean operational data before loading into data warehouse.
Cleaning in the sense your merging data which comes from different source
38. What is slowly changing dimension?
Dimension attribute values may change constantly over the time. (Say for example customer dimension has
customer_id,name, and address) customer address may change over time.
39. What is difference between primary key and unique key constraints?
Primary key maintains uniqueness and not null values Where as unique constrains maintain unique values and null values.
40. What are the types of index?
Share This :
In the expression transformation create new out port in the expression write :sp.stored procedure name (arguments).
32. What is difference between Informatica power mart and power center?
- Using power center we can create global repository
- Power mart used to create local repository
- Global repository configure multiple server to balance session load
- Local repository configure only single server
Sequential(Run the sessions one by one
Concurrent (Run the sessions simultaneously)
34. What is main difference mapplets and mapping?
Reuse the transformation in several mappings, where as mapping not like that.
If any changes made in mapplets it automatically inherited in all other instance mapplets.
35. Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank
transformation will output?
5 Rank.
36. What is bitmap index?
A bitmap for each key value replaces a list of rowids. Bitmap index more efficient for data warehousing
because low cardinality, low updates, very efficient for where class.
37. Why need staging area database for DWH?
Staging area needs to clean operational data before loading into data warehouse.
Cleaning in the sense your merging data which comes from different source
38. What is slowly changing dimension?
Dimension attribute values may change constantly over the time. (Say for example customer dimension has
customer_id,name, and address) customer address may change over time.
39. What is difference between primary key and unique key constraints?
Primary key maintains uniqueness and not null values Where as unique constrains maintain unique values and null values.
40. What are the types of index?
- Bitmap index
- B-tree index
- Function based index
- reverse key and composite index.
- We used Bitmap index in our project for better performance.
0 comments:
Post a Comment