Interested to Buy Any Domain ? << Click Here >> for more details...
we r using aggregator with out using groupby?
- 7 Answers
- 22316 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
How do you convert single row from source into three rows into target?
How we can create indexes after completing the loan process?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
In warehouses how many schemas are there?
How are indexes created after completing the load process?
What are the tasks that can be performed using sq?
can anyone suggest best free Talend data integration training online
What are the main features of Oracle 8i with context to datawarehouse?
Explain how many types of dimensions are available in informatica?
Where do we use mapping variables in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the uses of etl tools?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
