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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 
Please let me know how we can implement the below scenario.
In a single mapping,more than 500 sources
(legacy,VSAM,relational) will be loading into only one 
target. Whenever I retreive the data(any record) from 
target, i need to find the details that the record belongs 
to which source.

Thanks in advance..
 Question Submitted By :: Jakka
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
Answer
# 1		 
Hi ,

After every Source qualifier transformation just keep an 
Expression with flag.
Dont go Single Source qualifier trans.
Keep 1 source qualifier trans for one table.  


Any corrections let me know ,,,,
srinu.srinuvas@gmail.com
 
Is This Answer Correct ?    2 Yes 1 No
Srinu
 
  Re: Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
Answer
# 2		 
Yes its possible through above logic…In addition to Srinu 
idea....you can understand very easy way. Suppose creare one
(specific src) insert script.. means  for 500 sources,500 
insert script,which loads data into one src/tgt…we can add 
one more column source_name  tht will be always coming 
source_name..so at the time of retrieving we can easily 
understand this records belongs which source/tgt  tbl.
 
Is This Answer Correct ?    0 Yes 0 No
Vdiwade
 
 
 
  Re: Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
Answer
# 3		 
Here i am assuming that your single warehouse table has 
data from more than one source,and you need to distinguish 
the data among the sources.

For this to accomplish you can have table which can have 2 
columns Datasourcename and ID.This table will have all the 
source list and ID column will be the surrogate key.

Now you need to alter your warehouse table by adding a new 
column called Source Identifier.

Now you have the architecture ready.

When loading your warehouse table just look up the first 
table for the source name and pickup the corresponding 
surrogate key and populate into the Source identifier 
column in the warehouse table.Use this Column(Source 
Identifier)to identify the sources.
 
Is This Answer Correct ?    0 Yes 0 No
Bidhar
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
Why use the lookup transformation ?  2
What is the status code?  1
In which circumstances that informatica server creates Reject files?  2
what is lookupoverriding?  1
What is difference macros and prompts?  1
how many tasks are there in informatica ? TCS3
how to join the two flatfiles using the joiner t/r if there is no matching port? Cegedim4
What is the difference between view and materialised view?  4
what is update strategy transformation ?  3
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?  2
what we require for D.modelling?  1
What is Micro Strategy? Why is it used for? Infosys2
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?  2
Define informatica repository? Wipro1
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.  2
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?  2
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?  2
What are the different types of Type2 dimension maping? CTS1
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?  1
How to generate the HTML output using Informatica. Wipro1
 
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