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
without table how to come first record only in oracle?
What is decode in static cache?
What are the types of data warehouses?
In informatica workflow manager, how many repositories can be created?
how to create user defined function (udf) in informatica
What the difference is between a database, a data warehouse and a data mart?
Define pmcmd command?
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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the difference between informatica 7.0 and 8.0?
What is target load order?
Tell me about MD5 functions in informatica
How can we use mapping variables in informatica? Where do we use them?
What are the differences between oltp and olap?
Why filter transformation is an active one?