we r using aggregator with out using groupby?
- 7 Answers
- 20894 Views
- HSBC, Principal Finance, I also Faced
- E-Mail Answers
Answer Posted / satya
If we use Aggregator without using group by option we will
get only one row from source. It is a default charater of
Informatica.
e.g If there are 20 rows in the source table and only
using SQ and followed by Aggregator then target table then
the target table will be populated by the last row coming
from teh source table.
| Is This Answer Correct ? | 47 Yes | 3 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain pmcmd command usage in informatica
In informatics server which files are created during the session rums?
If informatica has its scheduler why using third party scheduler?
How can you validate all mappings in the repository simultaneously?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the Process to creating lookup transformation in informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the need of etl tools?
What is sequence generator transformation in informatica?
How can we use mapping variables in informatica?
How many number of sessions can one group in batches?
