Please tell me What is difference between 8.0 and 8.1
Answer / abhinay
The major diff'es b/w 7.5 and 8.0 are
1.The look range introduced in 8.0
2.The manager is combined with Designer in 8.0
3.Parameter Set was introduced
4.Scd's are introduced in 8.0
5.Changes in Surrogate key in 8.0
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the job parameters?
What are the different types of lookups in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the flow of loading data into fact & dimensional tables?
Why we use parameters instead of hard code in datastage.
how does work server jobs?
Difference between sequential file and data set?
How to reverse the string using SQL?
How do u call shellscript/Batch file from DS?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha