Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



Hi All, I have three question. 1) How to remove the header and footer in a flat file in info..

Answer / sridhar k

hi pradeep,

1) to remove header go to session->mapping->source file->set file properties->advanced->no of initial rows escaped(1)

footer-> instr(col,'footer')=0

2)lot of ways u can achieve here giving one solution

SQ->RANKT/R(SELECT TOP NO OF RANKS 1) ->TGT
SQ->RANKT/R(SELECT BOTTOM NO OF RANKS 1)->TGT

Is This Answer Correct ?    8 Yes 3 No

Hi All, I have three question. 1) How to remove the header and footer in a flat file in info..

Answer / 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

Hi All, I have three question. 1) How to remove the header and footer in a flat file in info..

Answer / babu

Hi Pradeep,

SQL Query for your requirement
============================
SELECT Name,SUM(salary) OVER(PARTITION BY Name ORDER BY Name,salary) AS Salary, MONTH FROM SAMPLE

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,


write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,


What are the connected or unconnected transforamations?

2 Answers  


COM components can be used in Informatica

0 Answers  


HOW TO YOU LOAD TIME DIMENSION

1 Answers  


suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,


How will u pas the data with out debugger?

4 Answers  


What is the difference between a connected look up and unconnected lookup?

0 Answers  


tell me the push down optimization

2 Answers   Wipro,


What is an Integration service in Informatica?

0 Answers  


Categories