Are there any types of Dynamic Caches in informatica
Answers were Sorted based on User's Feedback
Answer / hai
dynamic cache is there. LKP dynamic cache...........
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / pa1
Dynamic Cache is there for look up t/r. But we need to look
up only on targets
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / maheedhar
I have answered no,kindly correct if am wrong
| Is This Answer Correct ? | 2 Yes | 12 No |
How to generate or load values in to the target table based on a column value using informatica etl tool.
Mapplets can you use an active transformation in a mapplet,
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
Define Pmrep command?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
What is the reusable transformation?
What is an aggregator transformation? it is active why cant it be passive explain?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what is parallel querying and what r hints.
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
What aer the out put files that the informatica server creates during the session running?