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
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 can we create rank using datastage?what is the meaning of rank?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between operational data stage (ods) and data warehouse?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what is the difference between == and eq in UNIX shell scripting?
In Datastage, how you can fix the truncated data error?
What is the difference between informatica and datastage?
How many types of views are there in a datastage director?
What a datastage macro?
What could be a data source system?
How do you reject records in a transformer?
What are the primary usages of datastage tool?
client know skid info?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the precedence of stage variables,derivations, and constraints?