In a table, 4 person having same salary. How to get Third
person record only?

Answer Posted / divesh chasta

informatica solution :
first we will create seq and then filter out the third
record by this condition mod(id%3)=0

from this we can get third record.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can a transformation be made reusable?

749


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1947


In informatics server which files are created during the session rums?

729


What is substr in informatica?

787


Parameter and variable differences

1705






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

1738


What are the measure objects?

769


scenario where i can use only concurrent execution of workflow.

2643


Write the prerequisite tasks to achieve the session partition?

735


If informatica has its scheduler why using third party scheduler?

897


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2380


Is there any target staging area in informatica not staging area

2229


what is $$$$?

1818


Explain what transformation and how many are there in informatica?

582


Can you use flat files in Mapplets.

2309