Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ravikumar
Hi,
You can Say LookUp is a Left Outer join.Your Source Table is
Left side table and Lookup table is right table.
Now you are trying to get total source records and
matching records from lookup table(right table).
Hope this helpls....
ravikumar.pasupula@outlook.com
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What are the modules in Power Mart?
what is granularity in Data ware House?
List few etl bugs?
What are the steps involved in etl process?
Compare ETL & Manual development?
Explain what is etl process? How many steps etl contains explain with example?
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.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is a materialized view log?
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 lookup table in etl testing?
Explain about the data integration suite features?
Explain about round-robi?
