how to get the first row without using rank t/r?
Answer Posted / moorthy g
In Source Qualifier Sql Override
Ex: Table Name: Dept1
SELECT DEPT1.DEPTNO, DEPT1.DNAME, DEPT1.LOC
FROM
DEPT1
WHERE ROWNUM=1
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Why do you use Mapping Parameter and mapping variable?
Explain how many types of dimensions are available in informatica?
Explain lookup transformation source types in informatica
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
write a query to retrieve the latest records from the table sorted by version(scd)
What is informatica powercenter repository?
Explain pushdown optimization and types in informatica
Define update strategy?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is different between the data warehouse and data mart?
Could you explain what is enterprise data warehouse?
Different sorts of metadata that stores in the storage facility?
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
Design a mapping to load the cumulative sum of salaries of employees into target table?
What do you understand by term role-playing dimension?