Interested to Buy Any Domain ? << Click Here >> for more details...
what is the incremental agrrigation?
- 2 Answers
- 7236 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anoymous
It is technique used to get aggregated data incrementally,
can be done at session level.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / hemlata
The first time you run an upgraded session using
incremental aggregation, the Integration Service upgrades
the index and data cache files. If you want to partition a
session using a mapping with incremental aggregation, the
Integration Service realigns the index and data cache files.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is left outer join?
what is incremantal aggregation?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
What do you understand by SOA of Informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what is the look up transformation?
How to retrieve last two days updated records?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
What is the difference between a shortcut of an object and copy of an object? Compare them.
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Why do we use DSS database for OLAP tools?
Teradata 
