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
- 11831 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
project Steps,hits, Project level HArd things,Solved methods?
How we can covert server job to a parallel job?
how to sort two columns in single job in datastage.
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 should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are datastage sequences?
What is the flow of loading data into fact & dimensional tables?
Define ds designer?
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
Why fact table is in normal form?
How to perform incremental load in datastage?
I have a few records just I want to store data in to targets cycling way how?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Terminate Activity
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
