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
- 3157 Views
- QualTech, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
How to delete data which is not in source table?
What are the steps involved in etl process?
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.
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
How many types of transformations supported by sorted input?
How to increase performance without changing anything in mapping.( In prod)
How to fine tune mappings?
what is data modeling?
what are the production issues in datastage?
Explain etl?
Explain the use lookup tables and Aggregate tables?
Explain me ETL project architecture in Detail?
dimension object created in oracle can be imported in designer?how?
where we cannot use sorter Transformation. if we use then we will not get correct data?
