How can you find out whether datastage process is running
or not in unix?
Answers were Sorted based on User's Feedback
Answer / shikha
ps -ef | grep phantom
This will give list of all the processes running on that
node along with time and job/sequence name
| Is This Answer Correct ? | 7 Yes | 0 No |
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
Define orabulk and bcp stages?
What is Horizontal transformation, vertical transformation,diagonal transformation?
Can you implement SCD2 using join, transformer and funnel stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
What all the types of jobs you developed?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
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
How can u write exception handling in seq file????
What is the project in datastage?