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
- 11428 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / bharath
hi,
use
row generater------------>peek
in designer and load emp table metadata at row gen
and give cycle as the type value=10000 which is
same for all records as u said..
thank u..
please correct if i am wrong...
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are the various kinds of containers available in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How to convert RGB Value to Hexadecimal values in datastage?
What is the difference between validated and compiled in the datastage?
Describe stream connector?
What is the process of killing a job in datastage?
Where do the datastage jobs get stored?
how do u catch bad rows from OCI stage? And what CLI stands for?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Can you highlight the main features of ibm infosphere information server?
What are the steps needed to create a simple basic datastage job?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the difference between datastage and informatica?
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 is the differentiate between data file and descriptor file?
