Interested to Buy Any Domain ? << Click Here >> for more details...
suppose we are using dynamic lookup cache and in lookup
condition the record is succeeded but in target it is failed
due to some reasons then what happened in the cache ?
- 3 Answers
- 7214 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / urs
When we are using the lookup cache as dynamic at first run
it will stores the all lookup table records into the cache
but second run it will check whether the incoming source
record having in the target table or not..if the record
exist in target table it will update otherwise it will
insert..this load type is done based on your condition
...nothing will happen in cache..
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / santosh kumar sarangi
Hi Urs, as you told, if record exit then it will update so
can you please clarify which one it will update cache or
target table. If it will update the target table the why we
need the update strategy T/R.
In my view, if any things updating in the dynamic look up
cache then it's responsibility of developer to update the
same in the target, other wise look up cache and target will
not be in sync,
| Is This Answer Correct ? | 0 Yes | 0 No |
IF THE LOOKUP CONDITION IS TRUE THEN THE RECORD IS LOADED IN
CACHE AS WELL AS IN TARGET BUT THE TARGET FAILED MEANS
RECORD ONLY LOADED IN CACHE.
IF IT IS WRONG MEANS PLEASE MAIL ME chandranmca2007@gamil.com
| Is This Answer Correct ? | 1 Yes | 4 No |
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
write a query to retrieve the latest records from the table sorted by version(scd)
h0w many versions have been developed of onformatica so far?
What are the different types of Type2 dimension maping?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
How many transformations can be used in mapplets.
What are the types of maping wizards that r to be provided in Informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Normalizer transformation is not involved in Mapplet.. why???
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
Teradata 
