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
- 6361 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 |
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
What are the various types of transformation?
What is a rank transform?
Define informatica repository?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What are the types of schemas we have in data warehouse and what are the difference between them?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
What are the mapping paramaters and mapping variables?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
Teradata 
