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 16991Post New CSC Informatica Interview Questions
Differentiate call by value and call by reference?
Why there is actually a need for the businesses to invest in a RDBMS tool in the present time?
How to specify the sequence in which sub modules needs to be built?
What is mysql slow query?
What is an example of an application service provider?
What is the use of partition by in sql?
what is a role instance ?
What are the different types of UDF's in Java supported by Apache Pig?
Describe HTML Entities with example?
What is the other name given to sex chromosomes?
What is shared libraries?
What is a cstr and what are its basic assumptions?
Name the most common input formats defined in hadoop?
What is condensate lift?
how do substitute a pattern in a string using re module