Is it passive or active when check and uncheck the box of
DISTINCT in Sorter transformation? why?
Answer Posted / deepu
I sorter is an Active Transformation,I u check the Distinct
option it will output only the distint rows from the
source .
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the need of an ETL tool?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Write the prerequisite tasks to achieve the session partition?
How to differentiate between the active and passive transformations?
What is the surrogate key?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is SDLC way of code development?
What is the session task and command task?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the restrictions of union transformation?
What is flashback table ? Advance thanks
What is source qualifier transformation in informatica?
what is the -ve test case in your project.