Informatica Data Warehousing guideline for job interview preparation.
Explore list of Informatica Data Warehousing frequently asked
questions(FAQs) asked in number of Informatica Data Warehousing
interviews. Post your comments as your suggestions, questions and
answers on any Informatica Data Warehousing Interview Question or
answer. Ask Informatica Data Warehousing Question, your question will be
answered by our fellow friends.
Informatica Data Warehousing Questions and Answers:
1 :: How many types of facts and what are they?
Factless Facts:Facts without any measures.
Additive Facts:Fact data that can be additive/aggregative.
Non-Additive facts: Facts that are result of non-additon
Semi-Additive Facts: Only few colums data can be added.
Periodic Facts: That stores only one row per transaction that happend over a period of time.
Accumulating Fact: stores row for entire lifetime of event.
There are three types of facts
1)Additive fact:a fact which can be summarized by any one of dimension or all dimensions EX:QTY,REVENUE
2)Semi additive fact:a fact which can be summarized for few dimensions not for all dimensions. ex:current balance
3)non additive fact: a fact which cannot be summarized by any of dimensions.ex:percentage of profit
2 :: How to import VSAM files from source to target. Do we need a special plugin?
As far my knowledge by using power exchange tool convert vsam file to oracle tables then do mapping as usual to the target table.
3 :: Whats the diff between Informatica powercenter server, repositoryserver and repository?
Repository is a database in which all informatica componets are stored in the form of tables. The reposiitory server controls the repository and maintains the data integrity and Consistency across the repository when multiple users use Informatica. Powercenter Server/Infa Server is responsible for execution of the components (sessions) stored in the repository.
4 :: What are variable ports and list two situations when they can be used?
We have mainly tree ports Inport, Outport, Variable port. Inport represents data is flowing into transformation. Outport is used when data is mapped to next transformation. Variable port is used when we mathematical calculations are required. If any addition i will be more than happy if you can share.
We can use variable ports to store values of previous records which is not otherwise possible in Informatica.
5 :: Is union Transormation is Active transformation?
By Definiation, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different from the actual number of rows.
Informatica Data Warehousing Questions and Answers:
1 :: How many types of facts and what are they?
Factless Facts:Facts without any measures.
Additive Facts:Fact data that can be additive/aggregative.
Non-Additive facts: Facts that are result of non-additon
Semi-Additive Facts: Only few colums data can be added.
Periodic Facts: That stores only one row per transaction that happend over a period of time.
Accumulating Fact: stores row for entire lifetime of event.
There are three types of facts
1)Additive fact:a fact which can be summarized by any one of dimension or all dimensions EX:QTY,REVENUE
2)Semi additive fact:a fact which can be summarized for few dimensions not for all dimensions. ex:current balance
3)non additive fact: a fact which cannot be summarized by any of dimensions.ex:percentage of profit
2 :: How to import VSAM files from source to target. Do we need a special plugin?
As far my knowledge by using power exchange tool convert vsam file to oracle tables then do mapping as usual to the target table.
3 :: Whats the diff between Informatica powercenter server, repositoryserver and repository?
Repository is a database in which all informatica componets are stored in the form of tables. The reposiitory server controls the repository and maintains the data integrity and Consistency across the repository when multiple users use Informatica. Powercenter Server/Infa Server is responsible for execution of the components (sessions) stored in the repository.
4 :: What are variable ports and list two situations when they can be used?
We have mainly tree ports Inport, Outport, Variable port. Inport represents data is flowing into transformation. Outport is used when data is mapped to next transformation. Variable port is used when we mathematical calculations are required. If any addition i will be more than happy if you can share.
We can use variable ports to store values of previous records which is not otherwise possible in Informatica.
5 :: Is union Transormation is Active transformation?
By Definiation, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different from the actual number of rows.
No comments:
Post a Comment