Answer / kiran

hai..,This is Kiran..,

Common error will get while Extraction ,Transforming and
loading the data into target.

1.Data Type Mismatches(eg:non-numeric field in numeric
field).
2.null values in not null fields.
3.fields size different.
4.data type sizes between sorce to target.

Answer / badri karthik

Source file not found.
Null value populated NonNullable column
Died with Signal 11(due to server down)

Answer / kpk

1) NLS - warning
2) Null value populated for a non null column
3) metadata mismatch - check the target databse data type
and lenght.
4) datatype mismatch - wrong datatype used
5) parallel loding not enabled (this is a fatal error in
parallel jobs if the database dosent have parallel loading
enabled - oracle 10g)

Answer / shan

FATEL ERROR

Answer / madhu

Broken Pipe,sigint,Dead lock if accessing Database objects,

Answer / raj

following is genral error that i faced.

1.Column mismatch or invalid no of column.
2.file opening error.
3.parameter are not defined or not given correct value.
4.mutex error
5.process time out.

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 Answers  

how to write server Routine coding?

0 Answers   Eric,

Notification Activity

0 Answers   CTS,

I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?

1 Answers   TCS,

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers  

what is snow flack schema?

2 Answers  

What is orabulk stage?

0 Answers  

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,