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 |
what is parallel querying and what r hints.
What is a parameter When and where do you them when does the value will be created
List the transformation in informatica.
Explain the different lookup methods used in informatica?
version controlling in informatica?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
What is the sequence generator transformation in informatica?
How to create or import flat file definition in to the warehouse designer?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
What are the different types of schemas?