when we use lookup,if have 5 records,if i dont need 1st and
2nd records..what will be the procedure to achieve by using
lookup?/
- 5 Answers
- 10688 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rk
use lookup override as
select *from emp minus select *from emp where rownum<=2
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / rambabu
Hi gurpreet, we cant use > simble with romnum,
the answer given by RK is obsolutly correct
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sujana
create a flatfile for 1st and 2nd records...keep lukup on dis table..if condition doesnt match it inserts the record (use not equal operator in condition)..
crct me if im wrong
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gurpreet
select from emp where rownum> 2;
se this in sql override
| Is This Answer Correct ? | 1 Yes | 9 No |
What is the session task and command task?
If u select groupby port in aggregator what is output and dont select groupby option what is output
Slowly changing dimensions, types and where will you use them
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
What is aggregate cache in aggregator transformation?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
explain different types of modeling.
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
What is a repository manager?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Teradata 
