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
- 38250 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 a standalone command task?
How are the sources and targets definitions imported in informatica designer?
What is data movement mode in Informatica and difference between them?
What is the Process to creating lookup transformation in informatica
I have a flat file, want to reverse the contents of the flat file
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Explain the difference between mapping parameter and mapping variable?
How can you generate reports in informatica?
Write the unconnected lookup syntax?
Why union transformation is an active transformation?
Enterprise data warehouse your projects phase by phase explain?
In development project what is the process to follow for an etl developer from day1
What is a mapplet/worklet in informatica?
