i have flat file and using unix how can i generate sequence
number into targer?
you can Use cat -n flatFile>Target to Generate line numbers.
| Is This Answer Correct ? | 6 Yes | 0 No |
How can you join flat file, oracle as a sources?
How do you import and export the datastage jobs?
What is a merge in datastage?
What is job control?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
Hi Vijay here For Four CPU's how many nodes will required?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
what is the main difference between sorragate key n primary key in one word
I have 100 records how can I load at a time from the single time
Two source files contains same meta data third file contains different data types can I funnel that file.
In which situations we can use normal and sparse lookup stages
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?