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
- 18387 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
Why update strategy and union transformations are active?
what are the Methods For Creating Reusable Transformations?
Can informatica load heterogeneous targets from heterogeneous sources?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is a filter transformation?
What are the different transaction levels available in transaction control transformation?
How to create or import flat file definition in to the warehouse designer?
What is a joiner transformation and why it is an active one?
Enterprise data warehouse your projects phase by phase explain?
Can anyone tell me the new features in Informatica 9 Version?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain the different kinds of facts.
what is index?how it can work in informatica
What is a difference between complete, stop and abort?
How an expression transformation differs from aggregator transformation?
