Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 46534 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 can one come to know wether the records loak into the target if we use update strategy
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
Quickly characterize reusable change?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
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.
how to join the two flatfiles using the joiner t/r if there is no matching port?
What is a passive transformation?
What is the Rankindex in Ranktransformation?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
Which transformation is needed while using the Cobol sources as source definitions?
Can you copy the session to a different folder or repository?
Teradata 
