Answer / abhishek kumar

using union transformation.........

Answer / murthy

use oracle join in SQL override

Answer / k bhavani durga

this can be used to join two sources coming from two
different locations or from the same locayion.for this
there mist be atleast one matching port and it is must to
specify one source as master and the other as detail.

it supports the following types of joins
1.normal
2.master outer
3.detail outer
4.full outer

Answer / prasanna

Using lookup is equivalent to outer join on source table.
As Bhavani said, if you want to join 2 heterogeneous
sources you cannot join in SQ. Then you need to use join.

Ex: you have 2 sources. One is a table in a DB and another
is a faltfile then you can only join using joiner.

Adv: you can perform operations similar to inner, left
outer, right outer and full outer. But using a lookup its
equivalent to left outer join on source.

It's always better to join a table which is small in SQ
then creating a lookup on it for better performance

Answer / k.rameshyadav

Lookup T/R is always is an alternate for joiner.
If the sources are same i.e homogenous we can perform join at database level.

what is dynamic insert?

0 Answers  

What are various etl tools in the market?

0 Answers  

Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

1 Answers   HCL,

Explain do we need an etl tool?

0 Answers  

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.

0 Answers  

Need Informatica Power Center 9.1 free download(for all windows version)

1 Answers   ABC,

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  

what are the reporting tools and difference between them?

0 Answers  

explain the methodology of Data Warehousing?(Polaries)

0 Answers  

What is Relational Integrity?

1 Answers