what is shared lookup&persistent lookup?
Answer Posted / anoymous
shared cache: Data in the cache can be shared between
multiple transformations. It is just sharing the lookup cache.
Persistence cache: The cache can be reused across multiple
session runs.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can we create multiple integration service on single repository?
How can one identify whether mapping is correct or not without connecting session?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
waht type of interface is used for testing the data in informatica
What is main use of mapplet?
what is degenerated dimension?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is workflow? What are the components of the workflow manager?
Define enterprise data warehousing?
What is session task and command task?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
write a query to retrieve the latest records from the table sorted by version(scd)