why sequence generator should not directly connected to
joiner transformation ?
Answer Posted / srinu
Mainly sequence generator is used to generate an unique id
dynamically.
We can not join this number against any column in other
tables...
So.. we can not connect sequence generator with joiner.
and also,
Main reason is joiner is a Active transformation.Means it
can alter the number of rows.
So, if u connect sequence generator with joiner the outcome
sequence will not be proper.
Any Queries or Corrections
'srinu.srinuvas@gmail.com'
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain constraint based loading in informatica
Different sorts of metadata that stores in the storage facility?
What is decode in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is standalone command task?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is deployment group?
permutations of mapplet
How to Create a folder using pmrep command?
What is the meaning of up gradation of repository?
Target increases every day even though no new record was inserted
Differences between connected and unconnected lookup?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is a grid in Informatica?