Answer Posted / singh
The relationship maintained by the Foreign key with its Base Table is referred to as relational integrity.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain do we need an etl tool?
What is a mapping, session, worklet, workflow, mapplet?
tell me few points when u become TL
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.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What are various etl tools in the market?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What are snapshots?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
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
What is staging area referring to?
Explain etl mapping sheets?
Compare etl & elt?
Explain do we need an etl tool? When do we go for the tools in the market?
what is the main role of FI on business