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
- 7058 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the features of connected and unconnected lookup.
Explain scd type 3 through mapping.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the way to execute pl/sql script using informatica mapping?
What you know about transaction control transformation?
Design a mapping to load a target table with the following values from the above source?
Implementation methodology
What are the advantages of using informatica as an etl tool over teradata?
can you please explain me pre session and post session options?
Explain sessions. Explain how batches are used to combine executions?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is meant by lookup transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
