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

Answer Posted / kamalakar

by using pre sql in source qualifier we can generate
sequence in the target

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State the differences between sql override and lookup override?

619


What is update strategy transform?

568


In how many ways we can create ports?

699


whats the logic to load the lower level of granularity of data to fact table.

1792


How would you copy the content of one repository to another repository?

550






Write the unconnected lookup syntax?

654


What are the types of schemas we have in data warehouse and what are the difference between them?

518


How many ways are there to do 'remove duplicate records in informatica'?

584


How to update a particular record in target with out running whole workflow?

1154


How can we remove the duplicates from flat file source?

574


What is a filter transformation and why it is an active one?

560


How many dimensions are there in informatica?

623


What is the format of informatica objects in a repository?

597


What are the different options available for update strategy?

575


What is an aggregator transformation?

615