Interested to Buy Any Domain ? << Click Here >> for more details...
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
- 2 Answers
- 5369 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / raj
Method 1:
In Order to get this , the file name has to be parameterized.
Row Generator ->
Source -> Column Generator -> Funnel -> Destination
Aggregator ->
Column Generator:
Create column named 'Count' starting with 1 and incrementing by 1. By this, the last row will have the value of1000 in the 'Count' column.
Aggregator:
Get max of count which is 1000.
We also pass the actual data through another link.
Aggregator count is passed into funnel which is the trailer count.
The three inputs
1. File name concatenated with timestamp is passed from row generator.
2. Actual data is passed directly after column generator.
3. Header count is passed through the third link.
are joined in a funnel stage.
As funnel needs same number of columns across all the input we set all other columns as NULL.
Method 2...
This is an easy method using after job sub routine.
After the job is complete run a after job sub routine to get record count from any link and append to the file
Similar operation could be done for the header record.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you reject records in a transformer?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the difference between datastage and informatica?
What are routines in datastage? Enlist various types of routines.
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How do you generate sequence number in datastage?
How to reverse the string using unix?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the types of containers?
Explain Quality stage?
How a server job can be converted to a parallel job?
Why do we use link partitioner and link collector in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
CHANGE CAPTURE
To see hidden files in LINIX?
