in which situations do u go for sequence generator ?

Answers were Sorted based on User's Feedback



in which situations do u go for sequence generator ?..

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

in which situations do u go for sequence generator ?..

Answer / purva

Create keys.
Replace missing values.
Cycle through a sequential range of numbers

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,


What are the different types of Type2 dimension maping?

2 Answers   CTS,


How is Data Models Used in Practice?

1 Answers  


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,


Explian the Process of deployment groups in informatica

0 Answers   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?

1 Answers   Polaris,


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

3 Answers   NTT Data,


How do you load only null records into target?

0 Answers  


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?

6 Answers  


Why update strategy and union transformations are active? Explain with examples.

0 Answers  


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,


what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,


Categories