Interested to Buy Any Domain ? << Click Here >> for more details...
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
2056list and discuss two approaches for updation of target table in Informatica and how they are different.
2107you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
3 6343where are the log files generally stored.Can you change the path of the file.what can the path be?
2439what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
1 4229
How can we use external procedural logic in informatica?
What are the different Lookup methods used in Informatica?
What is a staging area? What is the purpose of a staging area?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
what is the difference between cardinality and Nullability?
what is the meant by Normalization and de-normalization?
what is the difference between cardinality and Nullability?
what is data modeling?
Explain me ETL project architecture in Detail?
What is a mapping, session, worklet, workflow, mapplet?
what are the reporting tools and difference between them?
Can u access a repository created in previous version of Informatica?
what is the use of server?
When do we go for the tools in the market?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
