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
- 18467 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
can you please explain me pre session and post session options?
What are some examples of informatica etl programs?
What are the differences between source qualifier and joiner transformation?
Reusable transformation and shortcut differences
What is the use of transformation?
what is song in infrmatica...?
What is a transaction control transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How can a transformation be made reusable?
Is it possible to create multiple domains on a single Informatica server?
How to Create a folder using pmrep command?
Explain the features of connected and unconnected lookup.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Differentiate between a database and data warehouse?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
