What are the active and passive transforamtions?
- 2 Answers
- 6330 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saral mariyaprakasam
The active transformation can change the rows pass
through by it. The passive transformation can not make the
changes the rows pass through by it.
The active transformations are aggregator, application
source qualifier, custom, filter,joiner, Normalizer, rank,
router,sorter,source qualifier, transaction control,union,
update strategy,XML parser,XML source qualifier
transformations.
The passive transformations are custom,expression,
external procedure,input,lookup,output,sequence generator,
stored procedure transformations.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / swetha
An active transforamtion can change the number of rows that
pass through it.
A passive transformation does not change the number of rows
that pass through it.
| Is This Answer Correct ? | 1 Yes | 0 No |
can we override a native sql query within informatica? Where do we do it? How do we do it?
how can u load the data in time dimension?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
sorce is a flatfile only 1st and last row should insert to target how will u do?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
What is an aggregator transformation?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
What is CDC? How to implement CDC?
What is predefined event?
what is the size of u r source(like file or table)?
Can we create two repositories on same database instance in oracle?
what is the flow?
Teradata 
