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
- 11467 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
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?
How to read the length of word in unix?
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)
Describe stream connector?
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?
What are the components of ascential data stage?
Why do we use exception activity in Datastage?
Can you explain kafka connector?
What are stage variables, derivations and constants?
What is quality stage?
What are orabulk and bcp stages?
What is the purpose of pivot stage and types of containers in datastage
Differentiate between datastage and informatica?
What is the purpose of pivot stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
