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


Please Help Members By Posting Answers For Below Questions

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1741


What is an unconnected transformation?

669


What is parallel processing in informatica?

1033


What are mapplets?

826


What is flashback table ? Advance thanks

1485






Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1599


What are the restrictions of union transformation?

583


Mention few power centre client applications with their basic purpose?

540


Suppose we do not group by on any ports of the aggregator what will be the output?

582


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

605


What is the function of union transformation?

621


How you prepared reports for OLAP?

1157


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1566


Please let me know how to make Data masking in informatica..

1273


What are the settings that you use to configure the joiner transformation?

617