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
- 12798 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul
In Lookup transformation;
Unconencted is used when ever u want to call the same
transformation several times and u have one return port.
Use dynamic cache if u want to update the case while
updating the target table itself and static is untouched
with the cache.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
Answer / satyam
We use an unconnected transformation when we need one
return column from each row and it receives values from:
LKP expression from another transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between a repository server and a powerhouse?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How union transformation is used?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
What are the main features of Oracle 8i with context to datawarehouse?
Is it possible to revert a global repository to local one and why?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
can we create index and drop index in exsisting table while using infomatica
how to delete duplicate records by using filter transfermation?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
guys which is the best institute in banglore to learn informatica??
What are mapplets? How is it different from a Reusable Transformation?
Teradata 
