How many joins in Informatica

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Partition, what happens if the specified key range is shorter and longer

2031


scenario where i can use only concurrent execution of workflow.

2552


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

786


How to generate sequence numbers without using the sequence generator transformation?

649


Explain the different dimensions.

558






is it possible to index the data in cache of lkp transformation ?

1528


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1540


Explain how many types of dimensions are available in informatica?

599


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1626


Explain about Informatica server process that how it works relates to mapping variables?

628


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1566


Describe an informatica powercenter?

609


Implementation methodology

1266


Target increases every day even though no new record was inserted

1111


What is confirmed fact in dataware housing?

5698