Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 46483 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 |
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
what is session override?
How many ways a relational source definition can be updated and what are they?
i have 2 session s1 execute s2 load first session fail what is the reason?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
What is the difference between view and materialised view?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
what is confirmed dimension?
What are the limitations of joiner transformation?
Why we use ENABLE HIGH PRECISION in session properties?
To import the flat file definition into the designer where should the flat file be placed?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
Teradata 
