Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10755 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 |
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
can a port in expression transf be given the name DISTINCT
What are the different types of repositories created using informatica?
Can we use parameters of parameter file in presession command
What is Micro Strategy? Why is it used for?
what is inline view?
without table how to come first record only in oracle?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
How do you implement scheduling in Informatica?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What's the layout of parameter file (what does a parameter file contain?)?
Teradata 
