ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
 Question Submitted By :: Ajitforyou
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Answer
# 1		 
not possible
 
Is This Answer Correct ?    2 Yes 1 No
Arjun
 
  Re: How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Answer
# 2		 
It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.
 
Is This Answer Correct ?    1 Yes 1 No
Aakansha
 
 
 
  Re: How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Answer
# 3		 
Hi,
 I know this is possible but not sure how.. SQ is used for 
Homogenius sources. Anyone else please try to get a 
positive answer on this one.
 
Is This Answer Correct ?    1 Yes 2 No
Charan
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
How to improve the performance of Aggregate transformation? Dmss3
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/  3
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used? TCS3
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?  1
What are parallel querys and query hints?  1
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?  1
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?  4
what is the difference between Informatica7.1 & informatica 8.1  3
How to list Top 10 salary, without using Rank Transmission? Infosys7
Can you use the maping parameters or variables created in one maping into any other reusable transformation?  1
how do u move the code from development to production?  2
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY? Wipro1
What is the functionality of update strategy?  1
What is a design?  1
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?  2
Why we need XMLs? IBM2
What is a poling?  1
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why. CTS4
how to move the mappings from your local machine to claint place?  2
When the informatica server marks that a batch is failed?  1
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com