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 do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
tell me the push down optimization
What is a difference between complete, stop and abort?
what is the incremental agrrigation?
What is active and passive transformation?
What are roles and groups and benefits of using them?
What is expression transformation?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
without using emailtask how will send a mail from informatica?