what is lookupoverriding?
Answer / mansi
We can override the lookup query for a relational lookup.
We can enter the entire override, or we can generate and
edit the default SQL statement.
Override the lookup query in the following circumstances:
1.Override the ORDER BY statement
2.A lookup table name or column names contains a reserved
word
3.Use mapping parameters and variables
4.A lookup column name contains a slash (/) character
5.Add a WHERE statement
Is This Answer Correct ? | 2 Yes | 0 No |
what are types of dimentions?
what is mapping performence?
What are the features of complex mapping?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
What do think which one is the better joiner or look up?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Do you have knowledge in ralph kimball methodology
difference between repository database and repository service?
What did you do in source pre load stored procedure
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.