Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12712 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / balakrishna
select empno,name,deptno,loc from emp where rownum=1
and
first using sorter select asc,create expression t/r using the variable v_count=v_count+1,o_count=v_count after using the filter t/r to write condition o_count=1 connect filter t/r to target
and
source--->sq--->seq--->exp--->filter--->target
and
select * from emp where rownum=1minusselect * from emp where rownum=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What all are steps in up gradation of Informatica server?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to delete duplicate row using informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are multi-group transformations?
How to partition the Session?
What is dynamic cache?
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
Explain in detail scd type 2 through mapping.
Why filter transformation is an active one?
explain about unit testing? in real time?
What are the settings that you use to configure the joiner transformation?
