Interested to Buy Any Domain ? << Click Here >> for more details...
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
- 1 Answers
- 1544 Views
- I also Faced
- E-Mail Answers
Answer / ysindhureddy77@gmail.com
If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the scenario which compels informatica server to reject files?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
What is router transformation
How can u stop a batch?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
What is the role of informatica in project ?Like i showed financial projects?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
What is the Router transformation?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
how can u load the data in time dimension?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Teradata 
