Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
- 18 Answers
- 30624 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyothika
for eg,when v connect filter transformation (active) and
exp trfn (passive) to exp trfn.v get a notification
saying "not allowed".
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / etl maha maha maha muduru
yes valid.suppose take sequence generator t/r drag the
nextval port into exp t/r from exp t/r drag all ports into
router t/r,from router t/r drag default group into one target.
when u connect default group into target then it is passive.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / chandru
if the date is passed from one active an one passive cannot be connected to the passive transformation the mapping is not valid
but there is a possible way if we have expression(passive) an aggreatror(active) we can connect these active an passive transformation through joiner (active) transformation it is possible
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / suhel shaikh
Yes its valid we can pass the data from an active trans to
passive trans.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / zaheer
No, it is not possible to move data from ACTIVE & PASSIVE to
PASSIVE. Either both transformation should be ACTIVE or
PASSIVE in pipeline.
| Is This Answer Correct ? | 3 Yes | 5 No |
Differentiate between router and filter transformation?
what is parallel querying and what r hints.
Define Pmrep command?
how to import multiple flat files in to single target where there is no common column in the flat files
What is the main difference between a Joiner Transformation and Union Transformation?
what are the Methods For Creating Reusable Transformations?
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?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
in a table it has 200 rows the query is select 150 from tablename.whats the output
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
Enterprise data warehouse your projects phase by phase explain?
what is sql override?what is the use of it?
Teradata 
