in my lookup table i want to catch the recently updated
records from the source to target,how to achieve this and what
is last commit interval point for this?
- 2 Answers
- 6394 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / prasanna
BY using dynamic lookup cache it is possible
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
What does role playing dimension mean?
What do you understand by term role-playing dimension?
Explain the etl program with few examples.
r u done any partitions in ur project?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is a connected transformation?
What is informatica worklet?
How is union transformation utilized?
Explain the use of aggregator cache file?
how to load rows into fact table in data warehouse
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is transformation?
What is the commit type if you have a transaction control transformation in the mapping?
