R

• Sep 26th, 2006

You have to a string variable to input a date field, and while using it in mapping u need to convert it to date format . to_date(val,'format')

Answer Question  Select Best Answer

R

• Sep 26th, 2006

I think fact table contains foreign keys which are primary keys in dimension tables other than facts and measures.

Motilal

 Profile Answers by Motilal Questions by Motilal

• Sep 15th, 2006

All the primary keys of the connected dimension tables as foreign keys.

Answer Question  Select Best Answer

kusum

• Sep 27th, 2006

Whenever any source data is changed we need to capture it in the target system also this can be basically in 3 waysTarget record is completely replaced with new record(Type 1)Complete changes can be c...

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 22nd, 2006

CDC Changed Data Capture. Name itself saying that if any data is changed it will how to get the values. for this one we have type1 and type2 and type3 cdc's are there. depending upon our requirement we can fallow.thanksmadhu

Answer Question  Select Best Answer

dwinfo

 Profile Answers by dwinfo Questions by dwinfo

• Sep 28th, 2006

I think the question is :If EMPID is in 5th column/port(in source qualifier), DEPTNO is in 7th column/port(in source qualifier) and if we use No.of Sorted Ports as 2. How will informati...

Answer Question  Select Best Answer

kaliprasad

• Sep 28th, 2006

The new features in informatica 7.1 are:1.The repositry is going to create with 247 database objectsin informatica7.1 where as in informatica 6.0 repositry is createed with 172 database objects.2.union transformation is added newly in infomratica 7.1

Answer Question  Select Best Answer

srinivas

• Sep 28th, 2006

if we are using more business reules or more transformations then it is called complex mapping. If we have flat files then we use the flat as a sourse or we can take relational sources depends on the availability.

Answer Question  Select Best Answer

srinivas vadlakonda

• Sep 28th, 2006

Incremental aggregation is in session properties i have 500 records in my source and again i got 300 records if u r not using incremental aggregation what are calculation r using on 500 records again ...

gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 29th, 2006

its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.

Answer Question  Select Best Answer

Vamsi Krishna.K

• Oct 1st, 2006

hello,we have to update target table. if you are loading type-1 dimension,type-2 dimension data at target surly you have to do. this update can be done by two type.1. using update stratergy2. target update override.Thanks,vamsi.

Answer Question  Select Best Answer

Vamsi Krishna.K

• Oct 1st, 2006

if you selected commit type is target, once the cache is holding some 10000 records server will commit the records, here server will be least bother of the number of source records processed. if you s...

srinivas vadlakonda

• Sep 29th, 2006

Commits the data based on the course records

Answer Question  Select Best Answer

Vamsi Krishna K.

• Oct 3rd, 2006

Shortcut is a facility providing by informatica to share metadata objects across folders without copying the objects to every folder.we can create shortcuts for Source definitions Reusable transformat...

Answer Question  Select Best Answer

anand

• Oct 4th, 2006

definatly

Answer Question  Select Best Answer

Raj

• Oct 5th, 2006

its depends for client requirements.initially we have implement?high level design?.so,the client want to be normalized (snow flake schema) or de-normaliized data (star schema) which is used for their analysis.so we have implemented whatever their requirements

Answer Question  Select Best Answer

balaji

• Oct 5th, 2006

Hai,COM is technology developed by Microsoft  which is based on  OO Design .COM Componenets exposes its interfaces  at  interface pointer  where client access Components ...

Answer Question  Select Best Answer

lingesh

• Oct 5th, 2006

Yaa we can refresh materialized view. While creating of materialized views we can give options such as refresh fast and we can mention time so that it can refresh automatically and fetch new data...

Answer Question  Select Best Answer

sravangopisetty

• Oct 10th, 2006

Types of dataflows1.sequential execution.2.paralal execution3.control flow execution

Answer Question  Select Best Answer

sravangopisetty

• Oct 10th, 2006

Ading to the point it also increase the no of rows in target.Example if the condition is given as sal

pushpa

• Oct 3rd, 2006

An active transformation can change the number of rows that pass through it.In Router you have the default group .If you want we can drop all rows in the default group, by not connecting it ...

Answer Question  Select Best Answer

Where exactly dimension and fact tables are useful? Is it source or target?We are importing source directly from database and transforming and loading the data to target.Can anybody please send where they exactly it is useful?

rajani

• Oct 10th, 2006

Can you explain with some examples?Thanks.

samba

• Aug 22nd, 2006

Dimesions and fact tables are nothing but tablesDimesions and facts are targets for the mappingsfirst u have to load the data into dimensions these are called master tables after that by using transac...

Answer Question  Select Best Answer