Interested to Buy Any Domain ? << Click Here >> for more details...
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN
TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE
THERE?WHAT LOGIC?
- 1 Answers
- 6619 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / subhash
1)
JOB1: SRC---->COPY---->TGT
SEQuence:
START LOOP---->JOB1----->END LOOP Activity.
In TGT stage use 'Append' Mode.
By Looping 100 time, we can get 100 records in target.
2)
SRC---->Transformer---->TGT
By using Looping Variable in the Transformer, we can achieve
this.
Loop While Condition "@ITERATION <=100"
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Explain connectivity between datastage with datasources?
What is ds designer?
How a routine is called in datastage job?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How you Implemented SCD Type 1 & Type 2 in your project?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How you can fix the truncated data error in datastage?
What is active and passive stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the precedence of stage variables,derivations, and constraints?
What are the primary usages of datastage tool?
What is data partitioning?
Is the value of staging variable stored temporarily or permanently?
