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 to convert IBM Cognos generated XML to a readable XML format for ETL tools
What is the difference between a connected look up and unconnected lookup?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
what are the row and column separations in Flat Files
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
what r the values tht r passed between informatics server and stored procedure?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Write the different tools in the workflow manager?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
tell me the informatica architecture
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?