In SQL override write tha fallowing query select a.id,b.name,b.sal from

i have a source table

ID NAME SAL

101 A 1000
102 B 2000
103 C 1500

target load should be

ID NAME SAL

101 A 1000
101 B 2000
101 C 1500
102 A 1000
102 B 2000
102 C 1500
103 A 1000
103 B 2000
103 C 1500

Question Posted / raj

3 Answers
6274 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / raj

In SQL override write tha fallowing query

select a.id,b.name,b.sal from <table name> a,<table name> b

The above query is nothing but a cartesion product.

Is This Answer Correct ?

23 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the sequence generator transformation in informatica?

1092

How can we remove the duplicates from flat file source?

947

What is lookup change?

985

Briefly explain the aggregator transformation?

941

COM components can be used in Informatica

2312

lookup transformation with screenshots

3938

Implementation methodology

1653

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1046

What is blocking transformation?

1081

What are the performance considerations when working with aggregator transformation?

1094

How we can use union transformation?

988

What are the different ways to implement parallel processing in informatica?

1339

How to join three sources using joiner?

1028

How to create a non-reusable instance of reusable transformations?

1057

What are some examples of informatica etl programs?

886