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
4512 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

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers Wipro,

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers TCS,

How to do unit testing in informatica?

0 Answers

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers ITC Infotech, TCS,

What is rank index in rank transformation?

0 Answers

How can you change from reusable session into non-reusable session.

5 Answers Cap Gemini,

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers TCS,

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers IBM,

Is it possible to update the target table with PK?

1 Answers TCS,

What are the reusable transformations?

0 Answers Informatica,

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers

For more Informatica Interview Questions Click Here