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
- 13436 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / kiran
ok well vijay.ur quetion not proper k.
see u can use s_key,column genaretor stage.
and u can define user define query in source level and
populated to target like dbl click on source and set read
method is user deine and write query=select
rownum,ename,sal from emp(s/r table name).k
Thanks&Regards
kiran
9393363309
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is process model?
Can you explain players in datastage?
Difference between server jobs & parallel jobs?
Name the different sorting methods in datastage.
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
sed,awk,head
Define project in datastage?
Difference between data warehousing and olap?
How a routine is called in datastage job?
What is the difference between in process and inter process?
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
How to reverse the string using unix?
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?
Explain how a source file is populated?
Define Job control?
