How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / g. manthiramoorthy
Create Two Port in Exp. Trans
v_temp : v_temp+1
o_seq : IIF(ISNULL(v_temp),0,v_temp)
Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
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.
How can you validate all mappings in the repository simultaneously?
How is union transformation utilized?
Define mapping and session?
What is the use of an aggregator cache file?
Explain the different lookup methods used in informatica?
Explain sessions?
What is target designer and target load order?
Which development components of informatica have the highest usage?
What is the difference between informatics 7x and 8x and what is latest version?
Why sorter is an active transformation?
What is deployment group?
What is the maplet?
What is a mapplet/worklet in informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?