Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 14302 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / srinivas
Hi suraj no need to put first group by and then having
clause
we can give any order it will work
please check and let me know
| Is This Answer Correct ? | 1 Yes | 2 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
In which transformation you cannot drag ports into it?
What are the designer tools for creating transformations?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What differs when we choose the sorted input for aggregator transformation?
What is InformaticaPowerCenter?
Clarify the utilization of aggregator cache record?
Explain what transformation and how many are there in informatica?
What are the different transaction levels available in transaction control transformation?
expain about the tune parameters?
What are active and passive transformations?
How to create the source and target database connections in server manager?
Design a mapping to load a target table with the following values from the above source?
What is rank transform?
How do you load unique records into one target table and duplicate records into a different target table?
