in which situations do u go for sequence generator ?
Answers were Sorted based on User's Feedback
Answer / mahesh
In the Fallowing Situations we use Sequence Generator
Transformation
1)Creating Primary Key Values
2)Replacing The Missing Key Values
3)When You Apply the Cycle Through a Sequential Range Of
Numbers
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / purva
Create keys.
Replace missing values.
Cycle through a sequential range of numbers
| Is This Answer Correct ? | 5 Yes | 0 No |
What is the query to find nth highest salary? What is the use of cursors?
What is Session and Batches?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
What is the difference between OLTP and ODS?
Write the different tools in the workflow manager?
have you developed documents in your project? and what documents we develop in realtime?
How to improve the performance of Aggregate transformation?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?