i have an aggregater in my mapping and no group by port on
any column and i ampassing 100 rows through aggregater,so
how many rows i will get as out put from aggregater
Answers were Sorted based on User's Feedback
Answer / sreenivas
it will return 100th row of the source if group by port is
not selected in aggregator
thanks,
sreenivas
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / pooja
all rows will come, since its not grouped. if its group by,
then last row will be out.
| Is This Answer Correct ? | 3 Yes | 14 No |
why we use source qualifier transformation?
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
what is the difference between lookupoveride and joiner?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How the Informatica Server reads perameter file?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
in performance wise union is past,union all is past
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
What are the databases that informatica can connect to windows?
what is data driven?
What is the Rank index port in Rank transformation?
What is a sorter transformation?