Informatica:序列生成 [英] Informatica : Sequence generate

问题描述

不使用序列生成器 如何在信息映射中生成序列 ?

Without using sequence generator How can we generate sequences in informatica mapping ?

谢谢

推荐答案

好吧，就像其他人说的那样，我希望得到一个具体的问题，为什么您要避免使用序列生成器.话虽如此，如果我对序列生成器开放替代概念"，就会想到一些事情

Well, like others said, I would have preferred to get a specific question on why you are trying to avoid sequence generator. Having said that, if i open myself to "the idea of an alternate" to sequence generator, some things do come to mind

1. 如果映射相对简单，则可以嵌入oracle/db序列.nextval调用隐藏在源限定符中.

1. If you have a relatively simplistic mapping, you can embed a oracle/db sequence.nextval call hidden in the source qualifier.

您也可以将db/sequence调用嵌入到sql转换中.但要知道这会带来反效果.

you can embed db/sequence call in a sql tranformation too. But know that it would be anti-performant.

您也可以使用持久变量来实现序列生成器的行为，但是存在局限性和缺点.

you will be able to achieve a sequence generator behaviour using a persistent variable too, but there are limitations and downsides.

因此，再次，根据您要执行的操作和遇到的困难，您可能希望重新发布/编辑您的问题..也许可以获得更直接的答案.

So, again, depending upon what you are trying to do and where you are getting stuck, you might want to repost/edit your question.. and perhaps get a more direct answer.

这篇关于Informatica:序列生成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！