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
- 17335 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
Partition, what happens if the specified key range is shorter and longer
How does a sorter cache works?
Explain the different dimensions.
Is it possible to revert a global repository to local one and why?
How to generate sequence numbers without using the sequence generator transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Differentiate between sessions and batches?
What is the maplet?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is lookup change?
What is meant by lookup transformation?
Enlist few areas or real-time situations where informatica is required.
What is the difference between source qualifier transformations source filter to filter transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the use of an aggregator cache file?
