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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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 want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

What are the ETL tools available in DWH?

6 Answers   Mphasis,

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

Explain the code page compatibility?

0 Answers  

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

What do you mean incremental aggregation?

0 Answers  

How does the aggregator transformation handle null values?

0 Answers  

What is the difference between view and materialised view?

4 Answers  

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

what is semi-additive fact?where did u used?

2 Answers  

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

For more Informatica Interview Questions Click Here
Categories