Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 46560 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 i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
Can you create a flatfile target
Could any one to tell How to use the Oracle Analytic functions in Informatica?
Whatis the difference between View and Materialized View ?
What is log file,and where is it located,why u r using the log file
what is informatica metadata?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Is informatica power center designer has 64 bit support?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Teradata 
