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
Answer Posted / bharath
if inputlnk.col1%3= 1 then outputlnk.col1=inputlnk.col2
else inputlnk.col2
if inputlnk.col1%3= 2 then outputlnk.col2=inputlnk.col2
else inputlnk.col2
if inputlnk.col1%3= 0 then outputlnk.col3=inputlnk.col2
else inputlnk.col2
use above conditions in transformer stage
and then
change the column names using modify stage
as col1 = eno
col2 = ename
col3 = sal
let me know right answer, if i'm wrong...
..
Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Could anyone give brief explanation bout datastage admin
What is a merge?
Lookup constraints
Explain the situation where you have applied SCD in your project?
Define Routines and their types?
What are the types of containers and how to create them?
How do you start developing a datastage project?
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?
Give an idea of system variables.
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the difference between in process and inter process?
What are the stages in datastage?
What are the components of ascential data stage?
What is ibm datastage?
How you Implemented SCD Type 1 & Type 2 in your project?