SRC1 -> EXP -> AGGR ->
TGT
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?
Answer Posted / jack
Design wise it is not right. Since in the first pipe an
AGGR is there. It is not a valid mapping.
| Is This Answer Correct ? | 3 Yes | 3 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.
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the prerequisite tasks to achieve the session partition?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How are the sources and targets definitions imported in informatica designer?
What is a surrogate key?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Suppose we do not group by on any ports of the aggregator what will be the output?
What do you mean by enterprise data warehousing?
In informatica workflow manager, how many repositories can be created?
What do you mean by channel change?
what are the deliverables?in your project?
Explain constraint based loading in informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project