what is session override?
- 2 Answers
- 12263 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
session override is an option in informatica at session
level. Here we can maually give an sql query which is
issued to the database when the session runs. It is nothing
but over riding the default sql which is generated by a
particular transformation at mapping level.
correct me if i was wrong
| Is This Answer Correct ? | 14 Yes | 1 No |
How do you load unique records into one target table and duplicate records into a different target table?
How to load duplicate records in to a target table which has a primary key?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
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
how can we use sorter transformation in joins?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is the advantage of informatica?
how will you remove the duplicate records from flat file without using sorter?
what are the perameter and variable?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
What is depict expression change?
How to display First letter of Names in Caps?
Teradata 
