wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 8254 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 |
sorce is a flatfile only 1st and last row should insert to target how will u do?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
How can a transformation be made reusable?
what transformations are used for Variable port?
can we generate reports in informatica ? How?
what is system requirement(SR) & business requirement(BR)?
What is polling in informatica ?
What is the default source option for update stratgey transformation?
What is lookup transformation?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Teradata 
