Interested to Buy Any Domain ? << Click Here >> for more details...
What are the active and passive transforamtions?
- 2 Answers
- 7587 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 |
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what is the difference between repository & Intergration service
What is target designer and target load order?
what is flat file override?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What are the tasks that source qualifier perform?
How informatica process data means how informatica works?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
Teradata 
