why we use source qualifier transformation?
Answers were Sorted based on User's Feedback
Answer / vanitha
Source Qualifier Transformation basically converts
different data types to Informatica Compatible Data types.
The additional Feature of it to allow the developer to
override the SQL (Only while reading database sources) adds
better design in the map. [instead of having additional
Filters and Sorters].
Is This Answer Correct ? | 69 Yes | 2 No |
Answer / manoj
source qualifier transformation represent the records that
the informatica server reads when it runs a session.
Is This Answer Correct ? | 38 Yes | 8 No |
Answer / ankit
Source qualifier is the first transformation which reads
data from relation of FF source.
With SQ we can limit the source data or sort or aggregate
or remove the dupliate data via SQL Query.
Is This Answer Correct ? | 27 Yes | 7 No |
Answer / pooja amhed
hi,
we use SQ trans as 1st trans due to its properties. in SQ
trans i means at the begin of extracting of data its self
we can remove duplicate ,we can filter,join,override the
query,pre and post sql querey.... in orther words we use it
to impore the performance.
Is This Answer Correct ? | 16 Yes | 4 No |
Answer / vidya acharya
1. SOURCE QUALIFIER TRANSFORMATION represents the rows that informatica powercenter server reads from RELATIONAL or FLAT FILE SOURCE when it runs the session.
2. When relational or flat file source definition is added to the mapping, informatica server creates the SQ by default. thus, its a default transformation in informatica.
3. Any source(relational/flat file) cannot be read without using SQ as it converts the database specific datatype to informatica native datatype.
4. For relational sources, additional properties can be configured:
- join 2 or more table originating from same source
- source filter.
- number of sorted ports
- select distinct rows
- user defined join
- specify pre-sql and post-sql query
- sql override.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ravi kumar
This type of an active transmission. which allows to read the data from relational or flat file.
Ex: our source Or flat file is relational that session reads the data through source qualifier. so when ever our source is relational or flat file we must and should use this. with out source qualifier session cann't read the data. when it run time
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / srikanth reddy
source qualifier transformation mainly used in it converts
the data types into informatica level
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ashok teja
SQ/T IS USED TO CONVERTS THE DATA INTO INFORMATICA
UNDERSTANDABLE FORMAT...
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vankayalapati sankar
souce qualifies transformation we can use to reduce the perfomence tunning pupose and minimum four transformations cover in it.what are those 0ne resone two join the two table in this case we can use the joiner transfomation,secound resone filter condition applied in source filter option in source qualifier transformation in that case filter tranformation cover it.third resone distinct option we can use to dublicate records remove in that case sorter tranformation cover.fourth resone sql qerry write in sql qerry option use it.in that case lookup transformation cover
Is This Answer Correct ? | 1 Yes | 0 No |
How can you generate reports in informatica?
what is the difference between repository & Intergration service
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
To import the flat file definition into the designer where should the flat file be placed?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
can we have to do changes in session property when we are dynamically generating target files?
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Differentiate between source qualifier and filter transformation?
Which will beter perform IIf or decode?