"Change cache" in Informatica ?
Answers were Sorted based on User's Feedback
Answer / mohanreddybank
There are different caches we have in informatica
Static, dynamic,persistent,shared lookup cache
| Is This Answer Correct ? | 2 Yes | 0 No |
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
Why use shortcuts(Instead of making copies).
Which gives the more performance when compare to fixed width and delimited file ? and why?
Explain the etl program with few examples.
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
what are challenges that you faced in testing? give solution to it?
can you avoid static cache in the lookup transformation? I mean can you
Name at least 5 different types of transformations used in mapping design and state the use of each.?
how may sources can be used in a mapping at a time?(limit)
wht is cdc?how to use it in creation of mappings?