Hi friends,
I am new to datastage, i have one query in datastage any one
you please give reply to my post.
I have a workbook (excel sheet) named as eg: xxxx, in that i
have two tables emp(eid, ename, salary, deptno) and
dep(deptno, name, state). in my source i have ODBC
enterprise stage read the emp table and dept table join the
two table and write the dept no
10(eid,ename,salary,name,state) values in target().
Thanks,
Badari
No Answer is Posted For this Question
Be the First to Post Answer
How can we improve the performance in datastage?
how to get the unique records on multiple columns by using sequential file stage only
what is hash file
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
whats relation between configuration file and datasets?
What are stage variables?
what is normalization and denormalization
Is it possible to query a hash file?
What is a delta record? How you will read it?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks