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 / gurpreet

select from emp where rownum> 2;
se this in sql override

Is This Answer Correct ?    1 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How are the sources and targets definitions imported in informatica designer?

672


What do you mean by blocking transformation?

589


Mention few advantages of router transformation over filter transformation.

642


What are the different clients of powercenter?

604


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1635






What is a dimensional model?

585


What is the difference between a connected look up and unconnected lookup?

578


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

545


How to update a particular record in target with out running whole workflow?

1164


How do you load only null records into target? Explain through mapping flow.

1509


what is informatica metadata?

609


What is powercenter on grid?

699


What are active transformations.

1195


What is informatica etl tool?

556


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

582