Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between lookup override and souce
qualifier override ?
- 2 Answers
- 15462 Views
- Puma, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kunal
1) SQ Override- In case of SQ override the unwanted columns
are filtered out and the required columns based on some
filter condition returned as an input to the next
transformation.
LKP Override- In case of LKP override, look up conditions
are checked and the records passed to next
transformation.Look up override can be applied on source or
target table.
2) In case of SQ override user has to mention order by
clause when required.
In LKP override the look up trans. internally apply order
by clause and if user want to use order by clause, user has
to mark '--' to disable the lkp order by clause.
| Is This Answer Correct ? | 13 Yes | 1 No |
How to generate sequence numbers using expression transformation?
What is a command that used to run a batch?
Without using Lookup & Sequence Generator, How to generate Sequence?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
what are the Methods For Creating Reusable Transformations?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
When do you use sql override in a lookup transformation?
What is lookup change?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
checkout and checkin in informatica 8.6
Teradata 
