whether Sequence generater T/r uses Caches? then what type
of Cache it is
Answer Posted / anup
the seq t/r uses index cache for the sequential range of
numbers for the generated keys.
| Is This Answer Correct ? | 8 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?
list out all the transformations which use cache?
Enlist the differences between database and data warehouse.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are mapplets? How is it different from a Reusable Transformation?
Under which circumstances, informatica server creates reject files?
What are different types of transformations available in informatica?
What are batches?
Enterprise data warehouse your projects phase by phase explain?
design of staging area?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the prerequisite tasks to achieve the session partition?
How does the aggregator transformation handle null values?
What is the use of target designer?