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.

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers   Syntel,

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,

options available in sequence job to run,validate?

0 Answers   CTS,

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

how do u capture duplicates through sort & transformer

4 Answers  

What is the importance of the exception activity in datastage?

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,

Which algorithm you used for your hashfile?

0 Answers