What is the actual work done in Development and in the
production depts in building a datawarehouse.
Which dept is more interesting and career oriented .

Answer Posted / weff

Every one has its own Importence,
Every one will Dependent on other one,

Choose The Carrier as a Jnuior Role,,,,

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate sequence numbers using expression transformation?

729


What are the various types of transformation?

741


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6661


What if the source is a flat-file?

697


What is informatica? Why do we need it?

743






Why do we need informatica?

643


What is dimensional table? Explain the different dimensions.

768


What is flashback table ? Advance thanks

1593


What is a standalone command task?

775


Describe expression transformation?

735


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1504


What is meant by query override?

738


How can we create index after completion of load process?

687


Explain the etl program with few examples.

638


What is the commit type if you have a transaction control transformation in the mapping?

738