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?
Answer Posted / 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 |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is primary and backup node?
Enterprise data warehouse your projects phase by phase explain?
How we can create indexes after completing the load process?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to generate sequence numbers without using the sequence generator transformation?
How is union transformation utilized?
Why sorter is an active transformation?
What are the settings that you use to configure the joiner transformation?
tell me about your project functionality
What is decode in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to generate sequence numbers?
What are the differences between joiner transformation and source qualifier transformation?