what is sql override?what is the use of it?
- 4 Answers
- 15111 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 |
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
Explain incremental aggregation in informatica
What are teh different tasks that can be created in workflow manager?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
Enlist the tasks for which source qualifier transformation is used.
What are the join types in joiner transformation?
what is left outer join?
Teradata 
