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
Under what condition selecting sorted input in aggregator may fail the session?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a repository manager?
Define update strategy?
How to call shell scripts from informatica?
What do you mean by channel change?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is blocking transformation?
What is the difference between a repository server and a powerhouse?
Differentiate between Load Manager and DTM?
Clarify the utilization of aggregator cache record?
Whats the difference between informatica powercenter server, repositoryserver and repository?
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?
What are the new features of informatica 9.x at the developer level?