following scenario empsal table i want who exist one lakshs
sal above monthwise?
`
empsal
empid monthyear sal
1 jan2008 1000
2 march2009 50000
3 april2009 4000
4 feb2009 100000
5 jul2009 600000
6 dec 2008 90000
Answer Posted / animesh
Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain your project of banking domian.
Differentiate between source qualifier and filter transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What do you understand by SOA of Informatica?
Plz can any one say me how to get the informatica certification materials and dumps
What is the need of an ETL tool?
How you prepared reports for OLAP?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the different types of olap? Give an example?
Which files are created during the session rums by informatics server?
How will the document be delivered to me?
r u done any partitions in ur project?
What is sorter transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?