what is the significance of newlookup port in dynamic look up
When we configure a look up t/r to use a dynamic cache, the
designer automatically adds a port called "New Lookup Row"
to the look up t/r. This port indicates with a numeric value
whether the Informatica server inserts or updates the row in
the cache or makes no change in the cache.
To keep the lookup cache and the target table
synchronised, we pass rows to the target when the New Lookup
Row value is equal to 1 or 2.
| Is This Answer Correct ? | 5 Yes | 0 No |
write a query to get maximum salary from the employers table without duplicates....kindly help me
where actually the usage of push down optimization happens...
What is the use of incremental aggregation?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
What all are steps in up gradation of Informatica server?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
What are the main features of Oracle 8i with context to datawarehouse?
What are the types of data warehouses?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
what is the predefined port in dynamic lookup