i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
Answer Posted / rakesh
Hi Chandrasekar,
My intension was to specify the column that is generated using sequence generator as RANK PORT. So no matter of sorting..
Thanks.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
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.
r u done any partitions in ur project?
What is a code page?
Enterprise data warehouse your projects phase by phase explain?
Describe an informatica powercenter?
What is meant by LDAP users?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Can we create multiple integration service on single repository?
What is workflow monitor?
What is a dimensional model?
What is meant by query override?
Explain the types of transformations?
Which transformation is needed while using the Cobol sources as source definitions?
Different circumstance which drives informatica server to expel records?
Explain what are the different versions of informatica?