how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
- 1 Answers
- 2926 Views
- I also Faced
- E-Mail Answers
Answer / tcs
There is no particular rule that says that mapping has to be
partitioned.But we can do so to improve the performence.Yes,it
depends on the machine configuration, as it uses the system
memory to run those sessions
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain do we need an etl tool?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is a mapping?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
what is granularity in Data ware House?
what is a worklet?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
Can u access a repository created in previous version of Informatica?
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.
explain the methodology of Data Warehousing?(Polaries)
Teradata 
