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 
if i have records like these
(source table)
rowid     name
10001     gdgfj
10002     dkdfh
10003     fjfgdhgjk
10001     gfhgdgh
10002     hjkdghkfh

the target table should be like these by using expression 
tranformation.
(Target table)
rowid     name
10001     gdgfj
10002     dkdfh
10003     fjfgdhgjk
xx001     gfhgdgh
xx002     hjkdghkfh
(that means duplicated records should contain XX in there 
rowid)
 Question Submitted By :: Gayathri
I also faced this Question!!     Rank Answer Posted By  
 
  Re: if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Answer
# 1		 
create an output port and write the expression to replace 
values or create a stored procedure and call it expression 
transformation
 
Is This Answer Correct ?    0 Yes 1 No
Mfg
 
  Re: if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Answer
# 2		 
Through Dynamic lookup you can handle it very easily.
 
Is This Answer Correct ?    0 Yes 0 No
Rajendra
 
 
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
what is a time dimension? give an example?  2
how do u get the first record from 50,000 records ? TCS5
task is running successfully but data is not loded why?  1
What are Target Options on the Servers?  1
How many repositories can we create in Informatica?? Patni6
Why we use stored procedure transformation?  1
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ? HP6
What are the different options used to configure the sequential batches? Wipro1
how many tasks are there in informatica ? TCS3
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ? HP3
What is the default join that source qualifier provides?  1
Which transformation should we use to normalize the COBOL and relational sources? Lehman-Brothers2
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ? Target8
hw cn v elimate dublicate values from lookup without overriding sql? CTS6
Why we use partitioning the session in informatica?  1
Why we use lookup transformations?  1
what are the difference between Informatica 7.1 and 8.1?  4
What is the default source option for update stratgey transformation?  1
How to enter same record twice in the target table,explain?  3
What is a look up function? What is default transformation for the look up function?  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