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 to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
if u can't find what you are looking for in lookup table, how do you handle?
what is the meant by Normalization and de-normalization?
how do u implement unconn.stored proc. in a mapping?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
what are the concerns of OLTP and DSS systems?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
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
how would u estimate the size of Lookup transform data and index cache?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What do you understand by active and passive transformations?