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.

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

what is datastage job Monitoring

6 Answers   CTS,

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

How to Remove Duplicate using SQL?

0 Answers   CTS,