Interested to Buy Any Domain ? << Click Here >> for more details...
how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 4377 Views
- I also Faced
- E-Mail Answers
Answer / chintan thakkar
It should always be done at SQ level, that will improve the performance of the mapping since informatica stores a cache for aggregator transformation.
| Is This Answer Correct ? | 0 Yes | 0 No |
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
In Which Transformation We Can Use Having Clause In Informatica?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
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
where is the cache (lookup, index) created and how can you see it.
what is data modeling?
Define slowly changing dimensions (SCD)?
what is the difference between cardinality and Nullability?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What exact we can see in table?
how would u estimate the size of Lookup transform data and index cache?
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?
Teradata 
