when we use lookup,if have 5 records,if i dont need 1st and
2nd records..what will be the procedure to achieve by using
lookup?/
Answer Posted / sujana
create a flatfile for 1st and 2nd records...keep lukup on dis table..if condition doesnt match it inserts the record (use not equal operator in condition)..
crct me if im wrong
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If informatica has its scheduler why using third party scheduler?
Enlist few areas or real-time situations where informatica is required.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what are the deliverables?in your project?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain the types of lookup transformation?
What are the different ways to implement parallel processing in informatica?
How can we use batches?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Implementation methodology
Is it possible to create multiple domains on a single Informatica server?
What are the uses of etl tools?
How do you promote a non-reusable transformation to reusable transformation?
difference between repository database and repository service?
What is substr in informatica?