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

Hi gurpreet, we cant use > simble with romnum,
the answer given by RK is obsolutly correct

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1874


Explain how many types of dimensions are available in informatica?

760


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1843


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1381


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1890






Explain the different lookup methods used in informatica?

770


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

737


How to call shell scripts from informatica?

742


How do you update the records with or without using update strategy?

857


Which files are created during the session rums by informatics server?

903


What is informatica etl tool?

718


What is the use of target designer?

788


Does an informatica transformation support only aggregate expressions?

787


Where do we use mapping variables in informatica?

783


what is the size of your data warehousing?

1842