Interested to Buy Any Domain ? << Click Here >> for more details...
I have file with empid,empname and I want to load these two
fields along with sal in my target
1)salary must be same for all the records
2)I want pass the salary at run time
- 7 Answers
- 11366 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / saran
ihn the job
seq--->tfm----target
in tfm stage take extra col as salary and create parameter for that salary
and take one stg variable in this call the parameter and map to o/p link salary column
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do u catch bad rows from OCI stage? And what CLI stands for?
Define Routines and their types?
Explain how a source file is populated?
Define Merge?
Define data aggregation?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to Remove Duplicate using SQL?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are data elements?
How to RD using transformer?
How to manage date conversion in Datastage?
How to reverse the string using SQL?
What is the roundrobin collector?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Where do you see different stages in the designer?
