1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

In seqence generator transformation maximum limit is
reached,after reaching maximum limit how will u insert the
data

Question Posted / sunil.knl

Answers were Sorted based on User's Feedback



In seqence generator transformation maximum limit is reached,after reaching maximum limit how will..

Answer / shilpa

When a Seq Gen Transformation reaches its maximum value and
the sequence is not configured to cycle, the session fails.

Either you need to cycle the sequence or increase the end
value.

Is This Answer Correct ?    12 Yes 1 No

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will..

Answer / santosh kumar sarangi

If sequence generator reached the maximum limit and can't
increase then do as follows.

1. Reset sequence generator to 0
2. Add a expression transformation make an out put port
Out_put_port= max_val_previous_sequence_gen+new_current_val

In this case you can generate next max value.

Let me know if any things wrong.

Thanks $ Regards
Santosh Kumar Sarangi

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

What are the different types of Type2 dimension maping?

2 Answers   CTS,

What are the tuning techniques you applied during your last project

0 Answers  

EXL informatica Questions

0 Answers  




When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

What are the types of groups in Router transformation?

1 Answers   Informatica,

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

What are the uses of a Parameter file?

3 Answers   CSC,

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

For more Informatica Interview Questions Click Here
Categories