Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500

Source
---------
eno , ename, sal
001,ank,1000
002,behe,2000
003,raj,2500

Target
-------
header :DDMMYYYY24MMSS timestamp
body: 001,ank,1000
002,behe,2000
003,raj,2500
footer: count(eno),sum(sal)

how to implement the same in a FF tgt?

Question Posted / kuni_ankita

2 Answers
4477 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- h..

Answer / sachin

We can do it in two ways
1)in unix level.write a script to get the footer and header.
2)we can create 3 flows for header ,body and footer and append them one by one

Is This Answer Correct ?

1 Yes

0 No

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- h..

Answer / pooja

Watch Out this link:

https://www.youtube.com/watch?v=zKNVn9Rhn5o

It is similar to the question posted

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

Where can we find the throughput option in informatica?

0 Answers

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers Patni, TCS,

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers IBM, Polaris,

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers IBM,

What is Datadriven?

2 Answers Informatica,

Can we get 1st record through Informatica(without sequence number).

0 Answers

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers Accenture,

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers Accenture,

What is InformaticaPowerCenter?

0 Answers Informatica,

How do you remove duplicate records in informatica?

1 Answers

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers Accenture,

For more Informatica Interview Questions Click Here