Answer Posted / mike
I think yes
for an unchached lookup table for every input roe the
lookup will query the lookup table to get the required rows.
HOpe this helps correct me if i was wrong
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What the difference is between a database, a data warehouse and a data mart?
Explain scd type 3 through mapping.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the use of source qualifier?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the databases that informatica can connect to windows?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the new features of informatica 9.x in developer level?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What does “tail –f” command do and what is its use as an Informatica admin.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Enlist the tasks for which source qualifier transformation is used.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how to load rows into fact table in data warehouse