In EMP table, for those emp whose Hiredate is same, update
their sal by "sal+500" or else for others keep the sal as it
is, how to do it by SQL query
Answer Posted / sbvp
update emp set sal=sal+500
or
alter table emp modify sal=sal+500
Is This Answer Correct ? | 1 Yes | 28 No |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
According to his methodology what all you need before you build a datawarehouse
explain one complex mapping with logic? sales project?
what are the deliverables?in your project?
Define update strategy?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain joiner transformation in informatica
How can we use batches?
Explain the etl program with few examples.
What is a sequence generator transformation?
How can you increase the performance in joiner transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the format of informatica objects in a repository?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Can we get 1st record through Informatica(without sequence number).