How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / sathish
use expression transformation
create two ports
one is assigned with it to zero
another one is assigned in outputport with expression logic
is o_seq=v_seq+1;
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What are the components of Informatica? And what is the purpose of each?
How can we create index after completion of load process?
What is the use of target designer?
Explain joiner transformation in informatica
what is INFORMATICA TESTING process
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
explain about unit testing? in real time?
What is persistent lookup cache?
What can we do to improve the performance of informatica aggregator transformation?
What is workflow monitor?
Can informatica load heterogeneous targets from heterogeneous sources?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is decode in informatica?
How to open an older version of an object in the workspace?