in which situations do u go for sequence generator ?
Answers were Sorted based on User's Feedback
Answer / mahesh
In the Fallowing Situations we use Sequence Generator
Transformation
1)Creating Primary Key Values
2)Replacing The Missing Key Values
3)When You Apply the Cycle Through a Sequential Range Of
Numbers
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / purva
Create keys.
Replace missing values.
Cycle through a sequential range of numbers
Is This Answer Correct ? | 5 Yes | 0 No |
i have 2 session s1 execute s2 load first session fail what is the reason?
What are the different types of Type2 dimension maping?
How is Data Models Used in Practice?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explian the Process of deployment groups in informatica
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
How do you load only null records into target?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
Why update strategy and union transformations are active? Explain with examples.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).