Interested to Buy Any Domain ? << Click Here >> for more details...
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL
USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT
WILL TAKE ONLY THE LAST COLUMN WHY????
- 3 Answers
- 8143 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prathap
IF GROUPBY IS NOT SELECTED INFORMATICA SERVER UNDERSTANDS WHOLE TABLE AS A ONE GROUP AND ITS GIVE LAST RECORD OUT
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / amedela chandra sekhar
Aggregator t/r perform calculations from first record to
last record.There is no group it will take last record
if u are not selected groupby the integration service returns
last record from all input rows.
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / amedela chandra sekhar
when u want to perform calculations on groups u can go for
aggregator t/r.aggregate functions like
min,max,last,first,count ...
if u are not selected groupby the integration service returns
last record from all input rows.
why means that integration service rule.
| Is This Answer Correct ? | 3 Yes | 7 No |
What is the need of an ETL tool?
Difference between task flow and linear task flow
Why filter transformation is an active one?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
waht type of interface is used for testing the data in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain pmcmd command usage in informatica
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
in performance wise union is past,union all is past
what is upstream and downstream transformation?
Teradata 
