Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7861 Views
- I also Faced
- E-Mail Answers
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
How can one find bugs in job sequence?
What are the different common services in datastage?
How the ipc stage work?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is ds designer?
State the difference between an operational datastage and a data warehouse?
Name the command line functions to import and export the DS jobs?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
I have a few records just I want to store data in to targets cycling way how?
Have you used Unstructured data?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are sequencers?
how to delete one row in target dataset
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How many types of stage?
