if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
Answer Posted / srinu
unonnected lookup
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is Active lock explain
Name the different lookup cache(s)?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Have you worked with/created Parameter file
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
how tokens will generate?
What is workflow? What are the components of the workflow manager?
How do you load alternate records into different tables through mapping flow?
What is dynamic cache?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is rank transformation?
What is the maplet?
What is an active transformation?
Which transformation is needed while using the Cobol sources as source definitions?