With out using Funnel Stage, how to populate the data from
different sources to single target
Answers were Sorted based on User's Feedback
Answer / sravanthi menam
Create schema file for all source files and take dataset to read the files and enable RCP.In output dataset give append mode
| Is This Answer Correct ? | 1 Yes | 2 No |
What is the Difference Between DataStage 7.5 version and 8.1 Version?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
how 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?
what is time dimension? and how to populate time demension
what are the errors,warnings in datastage
what is set mapping in datastage??
how to call routines in stages?
Where do the datastage jobs get stored?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
How do u set a default value to a column if the column value is NULL?
Why do you need stage variables?