What is Relational Integrity?
Answer / 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 |
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
Explain the key challenges that you face while performing etl testing.
Explain about hash partitioning?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What are the various tools used in etl?
How to know informatica conslole password??
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is the difference between round-robin partitioning and hash partitioning?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
Do we need an ETL tool? When do we go for the tools in the market?