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
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what is the Default Source Option For Update Strategy Transformation?
What is dimensional table? Explain the different dimensions.
Please let me know how to make Data masking in informatica..
Can we create two repositories on same database instance in oracle?
How to generate sequence numbers?
What are ETL Tools?
What is the difference between STOP and ABORT options in Workflow Monitor?
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.
How does a rank transform differ from aggregator transform functions max and min?
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?
How can we improve session performance in aggregator transformation?
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.
What are the types of caches in lookup? Explain them.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?