Interested to Buy Any Domain ? << Click Here >> for more details...
Hi All,
I have three question.
1) How to remove the header and footer in a flat file in
informatica?
2)How to load the first and last record of flat file into
the target?
3)I have a Input and Output table.
Input
Name Salaray Month
A 100 Jan
A 200 Feb
A 300 March
B 400 April
B 500 May
B 600 June
Output
Name Salaray Month
A 100 Jan
A 300 Feb
A 600 March
B 400 April
B 900 May
B 1500 June
How to implement and get the ouput as mentioned above.
If Possible kindly provide the SQL query also.
Kindly any one help to implement this concept.
Thanks,
Pradeep
- 3 Answers
- 18461 Views
- CSC, iNautix, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi Pradeep,
SQL Query for your requirement
============================
SELECT Name,SUM(salary) OVER(PARTITION BY Name ORDER BY Name,salary) AS Salary, MONTH FROM SAMPLE
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Define enterprise data warehousing?
Is there any target staging area in informatica not staging area
How many ways are there to do 'remove duplicate records in informatica'?
what are 3 tech challenges/ common issues you face?
What is the sql query overwrite in source qualifier in informatica
what is degenerated dimension?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is data movement mode in Informatica and difference between them?
what is $$$$?
How to load the data from people soft hrm to people soft erm using informatica?
How do you load only null records into target?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain pushdown optimization and types in informatica
What is domain and gateway node?
What is the difference between writing a joiner query in ANSI style and THETA style?
