Answer Posted / swetha
During the session ,the informatica server compares an inout
row with rows in the datacache. If the input row out-ranks a
stored row, the informatica server replaces the stored row
with the input row. The informatica server stores group
information in an index cache and row data in a data cache.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How does a sorter cache works?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
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?
can we override a native sql query within informatica? Where do we do it?
Describe the impact of several join conditions and join order in a joiner transformation?
How to extract the informatica rejected data?
What is the benefit of partitioning a session?
without table how to come first record only in oracle?
Global and Local shortcuts. Advantages.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is a filter transformation?
What are the mapping parameters and mapping variables?
Explain the tuning lookup transformation - informatica