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
- 38156 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 data transformation manager process?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is olap (on-line analytical processing?
What are the types of presistent cache in look up tr.
How to do unit testing in informatica? How to load data in informatica ?
Describe expression transformation?
Global and Local shortcuts. Advantages.
What are multi-group transformations?
What is a predefined event?
How can a transformation be made reusable?
What is a joiner transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain how to import oracle sequence into informatica?
Why do we need informatica?
