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
What is dimensional table?
During the running session, output files are created by informatica server. Enlist few of them.
wf dont have integration severances how you can run?
According to his methodology what all you need before you build a datawarehouse
What is an active transformation?
How can we use mapping variables in informatica?
What is lookup change?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain sql transformation in script mode examples in informatica
What is lookup transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the tasks that can be performed using sq?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is informatica worklet?
What is the benefit of partitioning a session?