Interested to Buy Any Domain ? << Click Here >> for more details...
Source
---------
eno , ename, sal
001,ank,1000
002,behe,2000
003,raj,2500
Target
-------
header :DDMMYYYY24MMSS timestamp
body: 001,ank,1000
002,behe,2000
003,raj,2500
footer: count(eno),sum(sal)
how to implement the same in a FF tgt?
- 2 Answers
- 4557 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sachin
We can do it in two ways
1)in unix level.write a script to get the footer and header.
2)we can create 3 flows for header ,body and footer and append them one by one
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pooja
Watch Out this link:
https://www.youtube.com/watch?v=zKNVn9Rhn5o
It is similar to the question posted
| Is This Answer Correct ? | 0 Yes | 0 No |
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
how to design mapping half of source table records into one target and remaining half into another target
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
What is metadata reporter?
How can you access the remote source into your session?
What is the difference b/w natural key and surrogate key
How might one distinguish in the case of mapping is right or not without associating session?
SO many times i saw "$PM parser error " .what is meant by PM?
What is a unit Testing?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
Teradata 
