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
Answer Posted / thangavel282@gmail.com
hi ...
they are asking run time so please use rcp
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
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 is a folder? Difference types of stages?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are stage variables and constants?
What is the difference between operational data stage (ods) and data warehouse?
what is the use of skid in reporting?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Have you have ever worked in unix environment and why it is useful in datastage?
What is the difference between validated and compiled in the datastage?
How do u convert the columns to rows in datastage?
What are sequencers?
What is the roundrobin collector?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are stage variables?