Interested to Buy Any Domain ? << Click Here >> for more details...
1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
- 4 Answers
- 12932 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / sreenu
Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.
Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Define pmcmd command?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to configure mapping in informatica?
According to his methodology what all you need before you build a datawarehouse
What are the basic requirements to join two sources in a source qualifier transformation using default join?
how we can load rejected record's at run time?(not through bad files)
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the informatica performance improvement tips
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is mapping debugger?
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?
how tokens will generate?
What if the source is a flat-file?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
