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
- 9223 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 |
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
What are the connected or unconnected transforamations?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
Difference between session variables and workflow variables?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
Differences between connected and unconnected lookup?
In a sequential batch can u run the session if previous session fails?
Briefly describe lookup transformation?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Teradata 
