How could we generate the sequence of key values without
using sequence generator transformation in the target ??

Answer Posted / arnab

either use oracle to generate the sequence number or use an
unconnected lkp transformation which looks up on the
target, get the max(value) of the column which has to be
incremented and increment the value by 1

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1820


what is the Default Source Option For Update Strategy Transformation?

1010


What is dimensional table? Explain the different dimensions.

953


Please let me know how to make Data masking in informatica..

1513


Can we create two repositories on same database instance in oracle?

877


How to generate sequence numbers?

853


What are ETL Tools?

876


What is the difference between STOP and ABORT options in Workflow Monitor?

982


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2563


How does a rank transform differ from aggregator transform functions max and min?

956


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1747


How can we improve session performance in aggregator transformation?

916


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2646


What are the types of caches in lookup? Explain them.

777


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

881