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 log file,and where is it located,why u r using the log file
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
What is the default join that source qualifier provides?
explan ur project architecture?
how u know when to use a static cache and dynamic cache in lookup transformation.
what is the difference between copy object import objects using repositery manager which one is best
What is the target load order?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
how can we perform incremental aggregation?explain with example?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...