how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 2489 Views
- QualTech, I also Faced
- E-Mail Answers
Answer / sajj
If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible
| Is This Answer Correct ? | 0 Yes | 0 No |
where is the cache (lookup, index) created and how can you see it.
Difference between flat files and relational sources?
what are Lookup caches options? Including persistent caches.
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
what is pmrep command?
how to connect to a flatfile through ftp in informatica
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
what are the reports developed in sap bw project and what is the requirement for developing it?
how do u extract data from different data sources explain with an example?
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
Teradata 
