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
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the reusable transformation?
What are the new features of informatica 9.x at the developer level?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a sorter transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is a node in Informatica?
What are the advantages of informatica?
What does role playing dimension mean?
Is there any target staging area in informatica not staging area
where to store informatica rejected data? How to extract the informatica rejected data?
What is the need of an ETL tool?
What is informatica powercenter repository?