How could we generate the sequence of key values without
using sequence generator transformation in the target ??
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 are the new features of informatica 9.x in developer level?
Explain target update override in informatica
Design a mapping to load a target table with the following values from the above source?
How can we improve session performance in aggregator transformation?
What are the mapping parameters and mapping variables?
Why do you use Mapping Parameter and mapping variable?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
whats the logic to load the lower level of granularity of data to fact table.
Can we create two repositories on same database instance in oracle?
What is aggregate cache in aggregator transformation?
What are the advantages of using informatica as an etl tool over teradata?
What are the reusable transformations?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
State the limitations where we cannot use joiner in the mapping pipeline?