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 / gd
select empid,monthyear from empsal where sal>100000;
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the different types of transformation available in informatica.
How to configure mapping in informatica?
How to generate sequence numbers without using the sequence generator transformation?
Can you use flat files in Mapplets.
differences between service based and product based?
What is a filter transformation and why it is an active one?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
In warehouses how many schemas are there?
Do you find any difficulty while working with flat files as source and target?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Differentiate between reusable transformation and mapplet.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is confirmed fact in dataware housing?
What are the different versions of informatica?