Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 46608 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 |
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
What is the use of incremental aggregation?
What is the main difference between a Joiner Transformation and Union Transformation?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
What are the unsupported repository objects for a mapplet?
why we use stored procedure transformation?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
Differentiate between reusable transformation and mapplet.
what is lookupoverriding?
Teradata 
