Interested to Buy Any Domain ? << Click Here >> for more details...
2,if we have 3 pipeline containing 3 targets and each target
is connected with diff sequence generator ,let us assume
first target is populated with seq no1-9,so what would be
the number generated by other two sequence generator?what is
the diff in o/p if when we use reusable sequence
generator?what would be the diff if we place expression in
between target and sequence generator?
- 2 Answers
- 6465 Views
- Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankur saini er.ankur861@gmail.
if we have diff seq gen for each target all three will
generate their independent seq to the targets depending
upon their current and inc valuses(what you configure)..
say 1-9 for target 1 . 1-9 for target 2 and 1-9 for target
3.
but if we are using reusable seq gen..then the seq divided
into the 3 targets ...exp 1-3 will go for target 1 then 4-6
will go to target 2 and 7-9 will go to target 3....it may
vary what target gets what seq.this is just an exapmle to
cliarify that whi seq will get distributed among the targets
Thanks
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sree
Each sequence generator generates numbers depending on
their start value and incrementby value.
If you are using reusable sequence generator and expression
trans is in between target and reusble sequence generator,
then all targets will be populated with the same sequence
numbers.
| Is This Answer Correct ? | 2 Yes | 2 No |
Using Expression transformation how to remove duplicate records from a relational source?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
What is galaxy shema
What is the difference between a shortcut of an object and copy of an object? Compare them.
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
Slowly changing dimensions, types and where will you use them
Can we insert ,update ,delete in target tables with one update strategy tran.?
What is the difference between SOURCE and TARGET BASED COMMITS?
Define error Threshold?
How to load duplicate records in to a target table which has a primary key?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
How can you complete unrcoverable sessions?
Teradata 
