in which situations do u go for sequence generator ?

Question Posted / chandra1983

2 Answers
9474 Views
TCS, I also Faced
E-Mail Answers

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

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers Motorola,

Differnce between filter and router?

14 Answers IBM,

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers

What are Dimensions and various types of Dimensions?

3 Answers PayPal, TCS,

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers

Briefly explain the aggregator transformation?

0 Answers

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers Sonata,

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers TATA,

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers IBM,

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers TCS,

What are the different types of transformation available in informatica.

0 Answers

Which is better performance wise database or file?How?

2 Answers TCS,

For more Informatica Interview Questions Click Here