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?
How many types of transformations supported by sorted input?
Compare ETL & Manual development?
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
how do u implement configuration management in Informatica?
What is etl process?
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.
where we cannot use sorter Transformation. if we use then we will not get correct data?
In Which Transformation We Can Use Having Clause In Informatica?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What is the difference between round-robin partitioning and hash partitioning?
How to fine tune mappings?
what make u disappointmnets in u r career
What are your responsibilities as an etl tester?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
