Interested to Buy Any Domain ? << Click Here >> for more details...
how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
- 1 Answers
- 3632 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 |
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
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?
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
explain the methodology of Data Warehousing?(Polaries)
what is the use of structures?how many nodes can u create in a structure?
Is apache nifi an etl tool?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is a mapping, session, worklet, workflow, mapplet?
What are materialized views & where do we use them?
Do we need an ETL tool? When do we go for the tools in the market?
Teradata 
