Interested to Buy Any Domain ? << Click Here >> for more details...
How could we generate the sequence of key values without
using sequence generator transformation in the target ??
- 12 Answers
- 37785 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / kalyan
Do a lookup on the Target table with an Lookup SQl Override
Select MAX(FIELD_NAME), field 1 , field3 from target group
by field1, field2...
In the Expression increment the Max values of the field
which you just got from the lookup by 1.
Here MAX_FIELDNAME) is the Max value of the field you want
to generate the sequence of..
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
What is parallel processing in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is incremental aggregation?
Explain the tuning lookup transformation - informatica
How to create or import flat file definition in to the warehouse designer?
Why update strategy and union transformations are active?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain lookup transformation is active in informatica
what is mean by complex business rule ?
What are the main features of Oracle 8i with context to datawarehouse?
How to generate sequence numbers?
Differentiate between Load Manager and DTM?
Different qualification between a related rotate toward the sky and isolates look upward?
Where is metadata stored?
