what is the process we used in joiner transformation,there is no matching colu

what is the process we used in joiner transformation,there
is no matching column in sources?

Question Posted / narasimha.inf

2 Answers
6774 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the process we used in joiner transformation,there is no matching column in sources?..

Answer / emmanuel

Create a dummy port in both the sq transforamtion and join
based on the dummy values

Is This Answer Correct ?

9 Yes

0 No

what is the process we used in joiner transformation,there is no matching column in sources?..

Answer / anithaks

I think we can use Union Transformation in such case!!

Is This Answer Correct ?

0 Yes

8 No

Post New Answer

More Informatica Interview Questions

How union transformation is active ?

2 Answers Puma,

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers

where to store informatica rejected data?

0 Answers

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers IBM,

Separate from an archive server and a powerhouse?

0 Answers

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers Accenture,

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers Informatica,

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers HCL, HP,

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers Sonata,

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers Franklin Templeton,

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers IBM,

For more Informatica Interview Questions Click Here