Interested to Buy Any Domain ? << Click Here >> for more details...
I want skip first 5 rows to load in to target? what will be
the logic at session level ??
- 1 Answers
- 7076 Views
- IBM, I also Faced
- E-Mail Answers
Answer / nitin
The one way to skip records for relational sources would be
adding a SQL Query in session properties.
SELECT * FROM EMPLOYEE
MINUS
SELECT * FROM EMPLOYEE WHERE ROWNUM <= 5
This query would skip the first 5 records.
| Is This Answer Correct ? | 7 Yes | 0 No |
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
if soource is having 10 records how will u insert 20 records to target
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
Global and Local shortcuts. Advantages.
What is a grid in Informatica?
HOW DO YOU CONNECT TO REMOTE SERVER ?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
What are the mapings that we use for slowly changing dimension table?
generate date / time dimension in informatica
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
Teradata 
