Interested to Buy Any Domain ? << Click Here >> for more details...
why sequence generator should not directly connected to
joiner transformation ?
- 1 Answers
- 10759 Views
- ANZ, I also Faced
- E-Mail Answers
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
Does an informatica transformation support only aggregate expressions?
How to improve the performance of a session using sorter transformation?
Explain load alternative records / rows into multiple targets - informatica
What do you understand by term role-playing dimension?
What are the types of presistent cache in look up tr.
What do you mean by filter transformation?
scenario where i can use only concurrent execution of workflow.
Explain sessions and how many types of sessions are there?
What all join we can perform in LOOKUP transformation?
How can we delete duplicate rows from flat files?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
wat are deployement groups in informatica, how it will be used for developers
Where can we find the throughput option in informatica?
How do you update the records with or without using update strategy?
What is the reusable transformation?
