what is sql override?what is the use of it?
- 4 Answers
- 16591 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 |
State the limitations where we cannot use joiner in the mapping pipeline?
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
How can we use mapping variables in informatica?
Why is meant by direct and indirect loading options in sessions?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Without source how to insert record to target?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
What are the new features of informatica 7.1?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
Teradata 
