Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql override?what is the use of it?
- 4 Answers
- 16231 Views
- Sonata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
When u want to override the default sql query we will use
sql override
| Is This Answer Correct ? | 22 Yes | 2 No |
Answer / soujanya
It is a process of writing user defined SQL queries to
define SQL joins,source filters, sorting input data and
eliminating duplicates
| Is This Answer Correct ? | 12 Yes | 0 No |
we can write the sql queries in sql override.by using this sql override we can reduce the no of t/r in a mapping.
if no please let me know the correct answer
| Is This Answer Correct ? | 8 Yes | 1 No |
It is a process of defining the user defined SQL queries to filter data, joining the data ,sorting the data and eliminating duplicate records.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the default join that source qualifier provides?
What do you understand by SOA of Informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Explain about HLD and LLD ?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
What is union transformation?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
What is Index Caches size?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
wht is cdc?how to use it in creation of mappings?
What are the restrictions of union transformation?
Teradata 
