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

How to load only the first and last record of a flat file into the target?

3 Answers Mind Tree,

What is a transaction control transformation?

0 Answers Informatica,

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers Cap Gemini, IBM,

What is souce qualifier transformation it is active or passive

2 Answers HCL,

What is a code page?

0 Answers

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers DELL,

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers

What is a candidate key?

7 Answers CTS,

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers CTS,

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,

How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers Syntel,

For more Informatica Interview Questions Click Here