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?
Answers were Sorted based on User's Feedback
Answer / ankit kansal
Unconnected Lookup is a better option as It will fire a sequel query whenever it was being called from other transformation using :LKP.lkp_trans(fieldname).
Or
Create a persistence cache for that table if it's not getting updated frequently. and use this cache in different other jobs.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 0 Yes | 0 No |
What are ETL Tools?
expain about the tune parameters?
Explain the difference between a data warehouse and a data mart?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
Can we use the mapping parameters or variables created in one mapping into another mapping?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are different types of transformations available in informatica?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
sorce is a flatfile only 1st and last row should insert to target how will u do?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.