Interested to Buy Any Domain ? << Click Here >> for more details...
2,if we have 3 pipeline containing 3 targets and each target
is connected with diff sequence generator ,let us assume
first target is populated with seq no1-9,so what would be
the number generated by other two sequence generator?what is
the diff in o/p if when we use reusable sequence
generator?what would be the diff if we place expression in
between target and sequence generator?
- 2 Answers
- 6362 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / sree
Each sequence generator generates numbers depending on
their start value and incrementby value.
If you are using reusable sequence generator and expression
trans is in between target and reusble sequence generator,
then all targets will be populated with the same sequence
numbers.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Clarify the aggregator change?
whats the logic to load the lower level of granularity of data to fact table.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are pre and post-session shell commands?
How an expression transformation differs from aggregator transformation?
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 to load rows into fact table in data warehouse
Write the prerequisite tasks to achieve the session partition?
Differentiate between a repository server and a powerhouse?
How you prepared reports for OLAP?
What are the tasks that can be performed using sq?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain constraint based loading in informatica
