types of errors in datastage?
Answers were Sorted based on User's Feedback
Answer / sudhakar
source file not found
null value populated not nullable column
died with signal 11( due to server down)
fatal errors
nls-warning
meta data missmatch
datatype missmatch
parallel loading not enabled
field size different
data type size between source and target diff
column missmatch
file opening error
mutex error
process time out...
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / masthanchowdary
compilation errors.i.e vc++ compiler expired errors
Is This Answer Correct ? | 0 Yes | 0 No |
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
What are the different kinds of views available in a datastage director?
what is advantages of snowflake when it is used?
What is exact difference between Parallel Jobs and server Jobs..
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
How to clean the datastage repository?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
What is apt_config in datastage?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
What is container and then types?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...