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 |
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
how to load duplicate row in a target
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
can u any challenge your project?
What is standalone command task?
how to load rows into fact table in data warehouse
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
What is IQD file?
without matching columns in two tables. how can you join
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
how do the project develops? pls specify right from the start to end in step by steps.
what is mean by throghput? in informatica