1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085

What is datastage engine?

1183

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2068

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2136

Why null values are mapped as 0 in fact tables?

1008

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11749

List out the file extensions used in abinitio?

1095

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2212

any difficulitis have you phase while creating bo reports and how did u solve it

3455

How can you define user defied event?

1031

Do you think effective communication is necessary for data processing?

1221

What is size of a transaction and an array means in a datastage?

1315

How can one find bugs in job sequence?

1417

What is SAS informats?

1109

Can you define metrics designer?

1058