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
- 17007 Views
- CSC, iNautix, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi Pradeep,
These are columns in
Exp Trans:
name (input & output)
salary (input)
month (input & output)
V_Sal: if(old_name=name,v_Sal+sal,sal) (Variabkle port)
Olad_name=name (Variable port)
o_sal=V_Sal (output port)
connect only name,o_sal,month columns to the target
it gives you what u r expecting. get the
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is rank transform?
design of staging area?
How does a rank transform differ from aggregator transform functions max and min?
Explain the informatica workflow?
What is enterprise data warehousing?
Define mapplet?
What is a dimensional model?
Explain Dataware house architecture .how data flow from intial to end?
How can informatica be used for an organization?
How many types of sessions are there in informatica.please explain them?
Implementation methodology
What is an aggregator transformation?
What is a repository? And how to add it in an informatica client?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to extract sap data using informatica? What is abap? What are idocs?
