Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql override?what is the use of it?
- 4 Answers
- 16008 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 |
Mention a few design and development best practices for informatica?
how many ways can we implement SCD2?
Tell me about Propagate functions in informatica
what is flat file override?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is a pre-defined event and user-defined event?
Could any one to tell Fact table Partitioning?
how to load duplicate row in a target
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
What is target update override
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Teradata 
