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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3605


tell me the rules and responsblites in our project(my project is development)

1605


How to implement security measures using repository manager?

695


How can you differentiate between powercenter and power map?

729


What is primary and backup node?

803






Define the various join types of joiner transformation?

647


how many types of dimensions are available in informatica?

647


How do you load only null records into target? Explain through mapping flow.

1628


What is main use of mapplet?

760


How can we create index after completion of load process?

687


Explain the informatica workflow?

695


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2502


Can we create a node as a gateway node and the same node can be assigned to a grid?

727


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1849


What are pre and post-session shell commands?

851