ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
we r using aggregator with out using groupby?
 Question Submitted By :: Srinivasarao
I also faced this Question!!     Rank Answer Posted By  
 
  Re: we r using aggregator with out using groupby?
Answer
# 1
If we use Aggregator without using group by option we will 
get only one row from source. It is a default charater of 
Informatica.

e.g If there are 20  rows in the source table and only 
using SQ and followed by Aggregator then target table then 
the target table will be populated by the last row coming 
from teh source table.
 
Is This Answer Correct ?    2 Yes 0 No
Satya
 
  Re: we r using aggregator with out using groupby?
Answer
# 2
if u use aggregator t/r without using group by function u
get  one summirized result but group by option allows u get
deatil result.
for example .without using groupby u want see a releince
store sales .u will get sales of whole store but when uuse
group by u get imtemized sales result
storecode   itemname       sales 
101          vegetable      500
101          vegetables     700
101          electronics    5000
101          electronics    10000
101          cooldrinks      200
101          cooldrinks      500

result without groupby: store sales:17400
result with groupby: vegetables sales :1200
                     electronics sales: 15000
                     cooldrinks sales: 700
 
Is This Answer Correct ?    0 Yes 0 No
Naresharavetis
 
 
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.  8
How can yoU improve session performance in aggregator transformation?  6
What is Micro Strategy? Why is it used for?  1
What is difference between Mapplet and reusable transformation? Wipro5
what is lookupoverriding?  1
Hi All can anyone tell me where i will get Informatica training in Mumbai?  1
HOW DO YOU PARFORM INCREMENTAL LAOD ? SAIC4
what is meant by lookup caches?  1
How many number of sessions that u can create in a batch?  3
how to move the mappings from your local machine to claint place?  2
What are parallel querys and query hints?  1
What are the methods for creating reusable transforamtions?  2
what is dimension table?  8
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ? Target8
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance  1
Which kind of index is preferred in DWH?  2
how to declare array in plsql?  1
Differnce between filter and router? IBM4
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table? Wipro1
what is the diff b/w union and joiner and lookup?  3
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com