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 / 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 is the method of removing duplicates, without the remove duplicate stage?
What are the types of containers and how to create them?
Explain entity, attribute and relationship in datastage?
what is the use of surogate key in datastage
sed,awk,head
Explain ibm infosphere information server and highlight its main features?
how to export or import the jobs in .ISX file
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the types of containers?
how can we create rank using datastage?what is the meaning of rank?
Differentiate between datastage and informatica?
how to add a new records into source?
How many types of stage?
What are the various kinds of the hash file?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this