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

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 session override?

2 Answers Cap Gemini,

How to Join Tables my Source is having 15 table target is one?

4 Answers TCS,

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers IBM,

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers Patni,

How will u pas the data with out debugger?

4 Answers

Without source how to insert record to target?

6 Answers

surrogate keys usage in Oracle and Informatica?

5 Answers ITC Infotech, Oracle,

What is complex mapping?