1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 / srinvias

Answers were Sorted based on User's Feedback



i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load sh..

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

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load sh..

Answer / sudheer113

SELECT F1.COL1,F2.COL2,F2.COL3 FROM A F1,A F2 ORDER BY 1,2

Is This Answer Correct ?    0 Yes 0 No

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load sh..

Answer / kondeti srinivas

IF IT IS SOURCE FLAT FILE THEN SQL OVER RIDE WILL NOT WORK

IF IT IS FLAT FILE USE UNION TRANSFORMER AND
CONNECT 3 SAME SOURCE STRUCTURES OF FLAT FILES TO UNION T/F AND CONNECT TO TARGET. IT WILL GIVE THE REQUIRED OUTPUT

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

r u done any partitions in ur project?

0 Answers   TCS,

what is degenerated dimension table with scenario

2 Answers   HCL,

what is junk dimension

4 Answers   Cap Gemini,

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

How we can use union transformation?

0 Answers  




what is confirmed dimension?

6 Answers  

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

How we can create indexes after completing the load process?

0 Answers  

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

For more Informatica Interview Questions Click Here
Categories