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                      
tip   To Refer this Site to Your Friends   Click 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
in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?
 Question Submitted By :: Itsranjan
I also faced this Question!!     Rank Answer Posted By  
 
  Re: in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Answer
# 1
Filter,source qualifier
 
Is This Answer Correct ?    0 Yes 1 No
Uzval_vee
[Not Yet]
 
  Re: in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Answer
# 2
HI, UZVAL

PLEASE STATE HOW DO U USE UNCONNECTED LOOKUP FROM A SOURCE 
QUALIFIER

IN MY KNOWLEDGE WE CAN'T USE U/C LKP IN SQ BUT WE CAN USE 
IT IN OTHER TRFNs LIKE ROUTER, AGGR ETC.. WHERE EXPRESSIONS 
EVALUATION IS ALLOWED.

PLEASE REPLY IF I AM WRONG.
 
Is This Answer Correct ?    1 Yes 0 No
Vishnu_kr
 
 
 
  Re: in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Answer
# 3
Other than Expression we can call un connected 
transformation from Update strategy transformation only
 
Is This Answer Correct ?    0 Yes 1 No
Nagarjuna
 
  Re: in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Answer
# 4
I think we can use agg t/f and rank t/f for this 
we cant use filter ,update strategy t/f becoz in these two  
we wright the condition in conditions tab but not in ports .
 
Is This Answer Correct ?    0 Yes 2 No
Sid
 
  Re: in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Answer
# 5
Filter only used no other transformation cannot be used
..
 
Is This Answer Correct ?    0 Yes 1 No
Saran
 
  Re: in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Answer
# 6
hey friends 
we can use unconnected lookup with Exp 
transformattion,update stragy, and as i remeber once i used 
with filter
 
Is This Answer Correct ?    0 Yes 0 No
Abhishek
 
  Re: in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Answer
# 7
Filter, Expression & update strategy
 
Is This Answer Correct ?    0 Yes 0 No
Madhavan Eyunni
 
  Re: in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Answer
# 8
u can use any T/r based on Exp editor available in which 
t.r that t/r u can use .lkp value.u can use 
update ,agg,rank,filter,sq
 
Is This Answer Correct ?    0 Yes 0 No
Anil
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
What is checksum termnology in informatica? Where do you use it ? Deloitte1
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 CSC3
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ? Target6
what are the real time problems generally come up while doing or running mapping or any transformation?  2
What is Code Page Compatibility?  1
what are the difference between Informatica 7.1 and 8.1?  4
why do u use shortcuts in informatica.? iFlex3
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen. Accenture9
how many types transformations supported by sortedinput?  3
wht target override?wht advantages it has compare to target update? Polaris1
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 is source qualifier? SDS1
What is difference between partioning of relatonal target and partitioning of file targets?  1
what is the difference between static and dynamic TCS2
Which gives the more performance when compare to fixed width and delimited file ? and why? HP1
What is an MDDB? What is the difference between MDDBs and RDBMSs?  2
how to load duplicate row in a target  2
What are the different types of Type2 dimension maping? CTS1
What is A complex mapping?  2
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me  2
 
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