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

wat transf shud i use to achieve this

id sal id sal sum
src-1 20 tgt 1 20 40
1 20 1 20 40
2 15 2 15 35
2 20 2 20 35

Question Posted / guest

Answers were Sorted based on User's Feedback



wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 ..

Answer / uma

Source -> SQ -> Agg T/F to get sum (group by id) -> Joiner (to join SQ and output of aggr transformation) -> Target

Is This Answer Correct ?    7 Yes 1 No

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 ..

Answer / rk

Use analytical function if source is database..
SELECT ID, SAL, SUM(SAL) OVER (PARTITION BY ID) AS SUM from table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

Can you start a session inside a batch individually?

2 Answers  

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

What are the ETL tools available in DWH?

6 Answers   Mphasis,

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

What are active transformations? Name them.

1 Answers  

What are the types of lookup transformation?

0 Answers   Informatica,

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

For more Informatica Interview Questions Click Here
Categories