Interested to Buy Any Domain ? << Click Here >> for more details...
A flatfile contains 200 records.I want to load first 50
records at first time running the job,second 50 records at
second time running and so on,how u can develop the job?pls
give the steps?pls pls
- 7 Answers
- 33072 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / msk22
Follow the steps:
1: import source definition(relational or flat file)
2: create mapping parameter $$m_count with datatype double
3: create expression transformation map all the output ports of source qualifier to expression.
4: create a variable port v_cnt and in expression write v_cnt+1
5: create an output port o_cnt and assign v_cnt to it.
6: take filter transformation, map all the output ports to filter and in filter condition write o_cnt<$$m_count and o_cnt>$$m_count-50
7: map all the output ports to target and save the mapping.
8: create a workflow for the mapping and then create a workflow variable $$wf_count with double datatype and enable persistent option.
9: create an assignment task and in the expression tab for user-defined variable choose $$wf_count and for expression write $$wf_count+50.
ex: $$wf_count=$$wf_count+50
10: now create the session for the mapping and go to session properties then select components tab, go to pre-session variable assignment column then open value and then there select mapping variable $$m_count and parent workflow variable $$wf_count
ex: $$m_count=$$wf_count.
11: save the workflow and execute.
That's it.......
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we use link partitioner and link collector in datastage?
What are the different types of lookups in datastage?
explain about citrix scheduling tool in datastage
Nls stands for what in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Why do you need stage variables?
What are routines in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is usage analysis in datastage?
How can we improve performance of data stage jobs?
Can you explain tagbatch restructure operator?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the difference between account and directory options ?
how to implement scd2 in datastage 7.5 with lookup stage
What is the project in datastage?
