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 is informatica? Why do we need it?
write a query to retrieve the latest records from the table sorted by version(scd)
Which means the first record should come as last record and last record should come as first record and load into the target file?
can we override a native sql query within informatica? How do we do it?
Can anyone tell me the new features in Informatica 9 Version?
What is the different lookup cache(s)?
What can we do to improve the performance of informatica aggregator transformation?
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.
How will the document be delivered to me?
Enlist the tasks for which source qualifier transformation is used.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What do you mean by worklet?
What are the types of schemas we have in data warehouse and what are the difference between them?
How do you load first and last records into target table?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you