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
- 18435 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 are the restrictions of union transformation?
What are the different transaction levels available in transaction control transformation?
What are ETL Tools?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to update source definition?
How to call shell scripts from informatica?
What is lookup transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What all join we can perform in LOOKUP transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to create the source and target database connections in server manager?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
which one is better performance wise joiner or look up
What are the informatica performance improvement tips
Do you find any difficulty while working with flat files as source and target?
