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?
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 |
How we can create indexes after completing the load process?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
why do we go for update strategy tr in SCD rather using the session properties?
What is the procedure for creating independent data marts from informatica 7.1?
How do you set a varible in incremental aggregation
What is the status code?
can we override a native sql query within informatica? Where do we do it? How do we do it?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
Explain factlessfact table with scenario
what is the incremental agrrigation?
How to handle decimal places while importing a flatfile into informatica?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,