My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?
- 3 Answers
- 6200 Views
- I also Faced
- E-Mail Answers
Answer Posted / rayudu
If you select groupby on all the ports you will get distinct records only.
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
What are the different versions of informatica?
Can we create multiple integration service on single repository?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the need of an ETL tool?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the various types of transformation?
How to start a workflow using pmcmd command?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to delete duplicate row using informatica?
What is lookup transformation?
Tell me about Propagate functions in informatica
Can you generate sequence numbers without using the sequence generator transformation?
In warehouses how many schemas are there?
How can repository reports be accessed without sql or other transformations?
