how to load meta data
Answers were Sorted based on User's Feedback
Answer / vinoth
Can you please more specific in your question?
What will be the source ?
| Is This Answer Correct ? | 0 Yes | 0 No |
Go to column tab - Load - select metadata file
Thanks
www.datagenx.net
| Is This Answer Correct ? | 0 Yes | 0 No |
what is flow of project?
What is size of a transaction and an array means in a datastage?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What are the prerequisites for join stage
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
How the ipc stage work?
how does work server jobs?
what is the unix script to run the job? Please mention commands which we use often?
What is the purpose of pivot stage and types of containers in datastage
how to sort two columns in single job in datastage.
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?