Interested to Buy Any Domain ? << Click Here >> for more details...
What is souce qualifier transformation it is active or
passive
- 2 Answers
- 10303 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / smarati
It is active transformation because,
- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition
All the above increases/decreases the number of rows, so SQ
is active.
Thanks
Som
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / sushma
SQ transofrmation reads the rows from the source. It is an
active transformation.
| Is This Answer Correct ? | 4 Yes | 1 No |
What are mapping parametres and variables in informatica?
How can i set break points in debugging mode ? can explain steps please?
Why use shortcuts(Instead of making copies).
How to use Normalizer transformation?
how u know when to use a static cache and dynamic cache in lookup transformation.
.prm wirh repalce .txt is possible?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What all are steps in up gradation of Informatica server?
What is the difference between OLTP and ODS?
How to fix the etl bugs..Tell me the process?
what is degenerated dimension
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
Teradata 
