Interested to Buy Any Domain ? << Click Here >> for more details...
if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 9324 Views
- I also Faced
- E-Mail Answers
Answer Posted / suresh reddy
select eno,sal,sal+sal as totsal from ex GROUP BY sno,sal;
will give the output same as above
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
I have a flat file, want to reverse the contents of the flat file
What is flashback table ? Advance thanks
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 are the prerequisite tasks to achieve the session partition?
How do we call shell scripts from informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is native users?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the difference between writing a joiner query in ANSI style and THETA style?
Differences between version 7.x and 8.x.
What is a mapplet/worklet in informatica?
What is enterprise data warehousing?
Where is metadata stored?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
