How many joins in Informatica
Answers were Sorted based on User's Feedback
Answer / ravindra.15aug
Normally four joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join
Is This Answer Correct ? | 38 Yes | 2 No |
Answer / sanjaygupta1981
The Informatica supports the following types of joins:
• Normal
• Master Outer
• Detail Outer
• Full Outer
Normal join: discards all the rows of data from the master
and detail source that do not match, based on the condition.
SELECT * FROM employees, departments WHERE
employees.department_id = departments.department_id
Master outer join: discards all the unmatched rows from the
master source and keeps all the rows from the detail source
and the matching rows from the master source.
SELECT * FROM employees LEFT OUTER JOIN departments ON
(employees.department_id = departments.department_id)
Detail outer join: keeps all rows of data from the master
source and the matching rows from the detail source. It
discards the unmatched rows from the detail source.
SELECT * FROM employees RIGHT OUTER JOIN departments ON
(employees.department_id = departments.department_id)
Full outer join keeps all rows of data from both the master
and detail sources.
SELECT * FROM employees FULL OUTER JOIN departments ON
(employees.department_id = departments.department_id)
Is This Answer Correct ? | 23 Yes | 1 No |
Answer / srinivas
there are four types of joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / srinivas
there are four types of joins in Informatica
1) Normal join -- Equi join
2) Master join -- Left outer join
3) Detail join -- Right outer join
4) Full outer join -- Full outer join
Is This Answer Correct ? | 9 Yes | 7 No |
What are the different lookup cache(s)?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
Can we have a Mapping without a Source Qualifier?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
What are junk dimensions?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What is batch and describe about types of batches?
i have two source data there is no pk,fk how to join the two sources
how to get max value record into one target and remaining records into another target?
What do mean by local and global repository?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?