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 ?
- 6 Answers
- 8684 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas
hi dahrmendra,
HOw can you join two pipeline or two branches of single
pipeline to single target.
even in place of tgt if you have any active or passive t/r
is presented tat mapping wouldnt be valid.but yes in place
of tgt you can use any multi input group t/r and connect it
to tgt then its valid
| Is This Answer Correct ? | 7 Yes | 0 No |
Hi, Jeck.Thanks for the answer but could you please explain
me why keeping AGGR in 1st pipeline makes in invalid
mapping.Thanks in advance
| Is This Answer Correct ? | 2 Yes | 0 No |
Hi Mahesh,
This is not the right place to do marketting.
Here we share our technical issues and resolve the same.
There are many other ways to attract people for your
institue.
Please do not repeat such malfunctioning.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sarthak
If the column structure of the two pipelines are same...we
can use UNION t/f to pass data to single TGT instance
or
if we ll take 2 instances of TGT table.... then It ll be
correct...
else we can't connect two pipelines to single TGT instance
directly
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / sujatha
I think its wrong ...because aggr is an active trans and
exp is a passive trans....
as per the infa help ...
"You cannot connect an active transformation and a passive
transformation to the same downstream transformation or
transformation input group."....
| Is This Answer Correct ? | 4 Yes | 4 No |
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
What is the difference between a connected look up and unconnected lookup?
How to send duplicates to one target and unique rows to one target?target is empty
generate date / time dimension in informatica
Explain the use of aggregator cache file?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
Why touse stored procedure in ETL Application?
In informatica workflow manager, how many repositories can be created?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
Teradata 
