Detection of loop
How you can detect the loops?
Expert
Designer allows you to recognize the loops in one of the two ways: You may run the Check Integrity function that signifies the existence of any loops. You may select the Detect Loops command from Tools menu. In case there are loops, the Loop Detection viewer emerges; it specifies the joins forming the loop.
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Explain the Joiner transformation?
State functionality of the repository manager?
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
Describe how a scenario is employed for business rule?
Describe the differences between an extranet and an intranet.
Assume when a session fails subsequent to loading of 10,000 records in to target. How can we load the records from 10001 the record when we run session next time?
Write about the term APT_CONFIG within the data stage?
Explain the way to swap a db device along with other.
Explain the slowly changing dimensions?
18,76,764
1947219 Asked
3,689
Active Tutors
1437062
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!