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 is union transformation in informatica?
What happens when a session fails and you click on recover?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is meant by incremental aggregation?
How to join three sources using joiner? Explain though mapping flow.
Scheduling properties,whats the default (sequential)
What are batches?
Clarify the aggregator change?
What is a sequence generator transformation?
can anyone suggest best free Talend data integration training online
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the different lookup cache(s)?
Explain lookup transformation source types in informatica
What is meant by lookup transformation? Explain the types of lookup transformation?
What is mapping debugger?