Interested to Buy Any Domain ? << Click Here >> for more details...
how remove 1st 3 records & last 3 records in informatics
- 4 Answers
- 9745 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answer Posted / venky
after sq transformation use exp transformation in that add
one port,and take seq generator trans and its properties
reset is enable,and link to the port in exp trans,after
that take filter trans and condition port>3,after that use
sorter trans in that take port desc,after that take exp
trans and create another new port,after that take seq gen
trans in properties resert as enable and link to the new
port,afer that use filter trans condition new port>3 and
connect to target.
this is the process u can do u wil get the result.pls try it
correctly
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a predefined event?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Is it possible to use a client with different version than that of its Informatica server?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
expain about the tune parameters?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the tuning techniques you applied during your last project
Difference between Target-based loading and constraint-based loading?
Can you use flat files in Mapplets.
What is exclusive and normal mode for repository services?
What is standalone command task?
How to load data in informatica ?
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.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Enlist the advantages of informatica.
