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
- 14088 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi Sanjaygupta1981,
Can you please check the query once :
count(*) or count(hiredate).
Except Count(*) Your query looks good.
If any correctons in my advise please let me
know "srinu.srinuvas@gmail.com"
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
what are the deliverables?in your project?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the advantages of informatica?
Please let me know how to make encryption and decryption with example?
In informatics server which files are created during the session rums?
What is workflow? What are the components of the workflow manager?
What is joiner transformation in informatica?
Have you worked with/created Parameter file
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is meant by pre and post session shell command?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to load a Dimension ? and how to load a fact table?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
