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 |
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
What is informatica powercenter repository?
How to create Target definition for flat files?
What is meant by lookup transformation? Explain the types of lookup transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
What is a difference between complete, stop and abort?