Interested to Buy Any Domain ? << Click Here >> for more details...
Hi i am new to Informatica. I have few question's in
Informatica. Can any one respond, it will be appricaited.
Q.Is Flat File Contains the Dynamic Cache?
- 6 Answers
- 10075 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kt
We can use Dynamic lookup for source as Flat File.
Please dont put the wrong answers that may confuse other
people.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / abidu
Hi,
Did u mean ' can dynamic cache be used for flat files ?'
If this the question, then the answer would be NO.
Dynamic cache cannot be used for flat file.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sujana
now in 8 version v can keep lookup on flatfile also
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / uzval_vee
i guess it won't have any cache like that, cache is nothing
but a memory isn't it,flatfile is just file it will store
values according to our requirement
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mural
as your requirement in mapping
you can use lookup transformation
lookup transformation create different chaches
one of the cache is dynamic cache
| Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between a connected look up and unconnected look up?
How do you use reject loader.
what is unique constraint error ?
What is aggregator transformation in informatica?
What is DTM process?
How many mapplets u have created? and what is the logic used
what is the use of Data Mart?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
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 is meant by incremental aggregation?
Teradata 
