Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sunil
Lookup works as Master outer Join in informatica ..
Oracle--> its works as left outer join..
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how would u estimate the size of Aggregator transform data and index cache?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
what are the reporting tools and difference between them?
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
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.
How many steps etl contains?
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?
What is etl process? How many steps etl contains?
Explain do we need an etl tool?
Explain etl?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is Data Vault???
tell me few points when u become TL
what is the use of server?
how would u estimate the size of Lookup transform data and index cache?
