Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 47013 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashok j
When we drag and drop the source table to mapping designer,
it automatically comes up with the SQ. SQ tranformation can
send the data to next level trasformation or target.
With the property Sql override, you can perform the
operations from the database level like aggregation, filter
condition, Expressions, join etc by writing appropriate
quries.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / su
The source qualifier converts user defined data types to
informatica data types.
The sorce qualifier is automatically generated only for the
flat files,for other sources we need to create it.
The basic transformation that is used in informatica is
source qualifier transformation.
We can write sql query in this transformation and we can
even override the existing sql query.
Using this transformation we can even perform
aggregator,filter,expression,sorting and join
transformations also.
It is used to join the homogenous source types.
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / prabhakar
we can use sq t for connect source to target
here source can be a text,sql,what may be
but we connect to any format
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / ramana
When you add a relational or flat file source definition to
a mapping, you need to connect it to a source qualifier
transformation. the source qualifier transformation
represents the record that the informatica server reads when
it runs a sessions.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / suresh
Hello All,
1) it is act on Source,that is why ,when we drag the Source
file ,it will also come with that.
2) while uploading homogeneous data ,we can use SQ.
3)insted of using joiner,filter,aggerigator ,we can use SQ.
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / jagan
hello dear friends
9866055553 Actually source Qualifier is used for improve the
performance
like to join to tables we use joiner transformation and
aggregator and filter transformation
we can do this operation with out using this transformatios
in the SQ properties we need to do some settings and after
that we can load the in to that particular targets....
| Is This Answer Correct ? | 0 Yes | 7 No |
How is union transformation utilized?
What can we do to improve the performance of informatica aggregator transformation?
What is difference between stored procedure transformation and external procedure transformation?
What are the types of caches in lookup? Explain them.
What are the two modes of datamovement in informatica sever?
how to insert header after each group.
Explain the tuning lookup transformation - informatica
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
what is degenerated dimension
what is procedure to use mapping variable in source qualifier transformation? with example
what is confirmed dimension?
How u use pdf file in informatica source?
Teradata 
