Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

Question Posted / narasimha.inf

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

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

What is up date strategy and what are the options for update strategy?

2 Answers  

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

What are connected or unconnected transformations?

0 Answers   Informatica,

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

What is hash partition?

1 Answers  

For more Informatica Interview Questions Click Here
Categories