Interested to Buy Any Domain ? << Click Here >> for more details...
what types of repositories we can create in informatica?
in real time in which type of repository we will work on?
- 2 Answers
- 7983 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanthi
There are two types of repositories
LOCAL REPOSITORY:The metadata can be shared within the
repository.
GLOBAL REPOSITORY:The metadata can be sharable across the
repositories.
In real time we will work on global repositories
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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.
What do you understand by active and passive transformations?
how would u estimate the size of Lookup transform data and index cache?
What is the difference between Data Warehousing and Data Mining?
What is the difference between project backlog and product backlog?
Can there be sub steps of etl steps?
What is staging area referring to?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Mention few test cases and explain them?
what is the difference between cardinality and Nullability?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is virtual Data Warehousing?
Explain and compare etl & manual development?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
