Interested to Buy Any Domain ? << Click Here >> for more details...
Hi I have scenario like this
s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000
How can i get target table like that without using
Transformer stage?
- 8 Answers
- 13267 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / sindhu
row number column in sequential file
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datastage and datastage tx?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are the types of containers in datastage?
What are the processing stages?
How do you schedule or monitoring the job?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What could be a data source system?
What are stage variables and constants?
How can you write parallel routines in datastage PX?
What are some different alternative commands associated with "dsjob"?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
what is the use of skid in reporting?
How to convert RGB Value to Hexadecimal values in datastage?
Differentiate between datastage and informatica?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
