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 |
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is meant by incremental aggregation?
Explain target update override in informatica
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
How to recover the standalone session?
What is polling?
What is status code in informatica?
What did you do in source pre load stored procedure
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
what is confirmed dimension?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
how to delete duplicate records by using filter transfermation?