1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
1 5758Sequential 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?
TCS,
1 3457A 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?
TCS,
3 8637I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
IBM,
3 8133SEQUENTIAL 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?
TCS,
1 5773What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
1 5379hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
5 7932Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
7 8474my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
10 14566how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
3 21787
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Can you explain link buffering?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
I have a few records just I want to store data in to targets cycling way how?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the functionalities of link partitioner and link collector?
What is the difference between datastage and datastage tx?
Nls stands for what in datastage?
What are stage variables?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is orabulk stage?
Describe stream connector?
What is the method of removing duplicates, without the remove duplicate stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?