Interested to Buy Any Domain ? << Click Here >> for more details...
When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
- 3 Answers
- 12786 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinod saini
Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / veera
When/Under what circumstances do we use dynamic and static
cache in connected
lookup?
When/Under what circumstances do we use static cache in
unconnected lookup?
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / bc
we can use dynamic and static cache in connected
lookup..and we can use only static cache in unconnected
lookup.
| Is This Answer Correct ? | 0 Yes | 4 No |
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
How do you load first and last records into target table?
what is parallel querying and what r hints.
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Tell me about informatica architecture.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is log file,and where is it located,why u r using the log file
what is the command to get the list of files in a directory in unix?
Separate from a database, an information bazaar, and an information stockroom?
4 yrs etl devloper roles and responsibilities?any body give solutions
can you use flat file for repository?why?
Teradata 
