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
- 8144 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the modules in Power Center
What is the benefit of session partitioning?
How to update a particular record in target with out running whole workflow?
Have you worked with/created Parameter file
Differentiate between sessions and batches?
What are the different options available for update strategy?
what is mean by complex business rule ?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the use of target designer?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
tell me the rules and responsblites in our project(my project is development)
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is a stored procedure transformation?
