how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
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 |
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
What are the names of the layers in etl?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
Can we create Hierarchies in generic datasources?
Explain etl mapping sheets?
what is the difference between OLTP database and data warehousing database?
What are the differences between sql override and update override?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
what is Forward,Reverse and Re_engineering?
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
Identifying the bottlenecks in various components of Informatica and resolving them.
if i have a query as flat file how can we load data to target table