Interested to Buy Any Domain ? << Click Here >> for more details...
how will u design file watch jobs?
- 2 Answers
- 7534 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
Use wait for file activity in sequencer and then connect to job.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain usage analysis in datastage?
what is sparse lookup?
Why do you need stage variables?
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
Explain datastage architecture?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
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
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
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
Teradata 
