in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / chandra
override source qualifier
SELECT E.* FROM(SELECT ENAME,SAL,ROWNUM R FROM EMP) E WHERE
R IN (1,5);
HERE I TAKE EMP TABLE
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is a mapplet/worklet in informatica?
How to load last n records of file into target table - informatica
Explain sessions. Explain how batches are used to combine executions?
Can you generate sequence numbers without using the sequence generator transformation?
Explain the shared cache and re-cache?
What are the components of the workflow manager?
What is fact table? Explain the different kinds of facts.
In informatica workflow manager, how many repositories can be created?
Why do we need informatica?
Define filter transformation?
How to improve the performance of a session using sorter transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?