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
What is option by which we can run all the sessions in a batch simultaneously?
What is the format of informatica objects in a repository?
Explain the types of lookup transformation?
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
What is workflow? What are the components of the workflow manager?
During the running session, output files are created by informatica server. Enlist few of them.
What is different between the data warehouse and data mart?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
how to load dimension table and fact table. plz tell me the steps.
What is the use of target designer?
Is it possible to revert a global repository to local one and why?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the different clients of powercenter?
What could be the possible resons of locks by user?