Answer Posted / anand
For overwriting Data.Ex" we used to load Flat file data
from DSO to Cube.Its is Data Mart.Loading data from a
infoprovider used as data target to another data target.The
concept we used is DATA MART.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to elaborate powercenter integration service?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the difference between stop and abort in informatica
What is a dimensional model?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to generate sequence numbers using expression transformation?
How do we call shell scripts from informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
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?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Design time, run time. If you don't create parameter what will happen
which one is better performance wise joiner or look up
What are the differences between source qualifier and joiner transformation?
How does a sorter cache works?
What is decode in static cache?
