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 |
How to load duplicate records in to a target table which has a primary key?
what is incremental aggregation ,with example?
Design a mapping to get year of join for each employee.
What is limitations of truncate and load option
What is galaxy shema
What happens if we dont select data driven option?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
WAT IS TEXT LOAD?
What is the need for an etl tool?
Describe an informatica powercenter?
What are the uses of a Parameter file?
Informatica and datawarehousing courses in Pune?