Interested to Buy Any Domain ? << Click Here >> for more details...
wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 9034 Views
- CTS, I also Faced
- E-Mail Answers
Answer / bsgsr
i believe this should work.
1) use the first and last functions of aggregate t/tion.
2) use the top option and 1 rank using rank t/tion
similarly last option and 1 rank to get only the first
and lst records.
3) else connect the flat file to filter t/tion. create new
port in filter name it s_no and connect the nextval port of
s.gen and write the contion (assume the file contains 100
records) like s_no=1 or s_no=100
| Is This Answer Correct ? | 5 Yes | 1 No |
How informatica recognizes mapping?
What is informatica powercenter repository?
Explain what are the different versions of informatica?
How to handle decimal places while importing a flatfile into informatica?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
What are the conditions needed to improve the performance of informatica aggregator transformation?
How would you join a node to the already existing domain?
How do you update the records with or without using update strategy?
What is the difference between Bitmap and Btree index?
why we are using surogate key in real time give me explanation
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
Teradata 
