What are the active and passive transforamtions?
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 |
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
In which scenario did you used pushdown optimization?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explain what are the different versions of informatica?
How we can confirm all mappings in the repository simultaneously?
what is the difference between stop and abort?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
How to recover the standalone session?