WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER?
chandumba2005@gmai.com
Answer Posted / srinivasulu raju
It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...
Condition: Source must be DataBase.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is deployment group?
Is there any target staging area in informatica not staging area
Explain why we use partitioning the session in informatica?
How can repository reports be accessed without sql or other transformations?
What are the different clients of powercenter?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Is it possible to create multiple domains on a single Informatica server?
Explain the different kinds of facts.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain the informatica workflow?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How we can use union transformation?
How to create or import flat file definition in to the warehouse designer?