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

My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?

Question Posted / ashok

Answers were Sorted based on User's Feedback



My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggr..

Answer / rayudu

If you select groupby on all the ports you will get distinct records only.

Is This Answer Correct ?    22 Yes 0 No

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggr..

Answer / abhinaw prakash

If u group by all the columns it will group the Data
sequentially according to the Port order and send it to the
Next transformation.

Is This Answer Correct ?    1 Yes 0 No

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggr..

Answer / kunkala.ramakrishna

ALL RECORDS SEND TO NEXT T/R

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1 Answers  

What are the new features of informatica 9.x at the developer level?

1 Answers  

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

How informatica process data means how informatica works?

2 Answers   TCS,

What are reusable transformations in how many ways we can create them?

2 Answers  

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

Is it possible to use a client with different version than that of its Informatica server?

1 Answers  

What are the features of complex mapping?

1 Answers  

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

What is the difference between a connected look up and unconnected lookup?

1 Answers  

For more Informatica Interview Questions Click Here
Categories