pallavi

• Nov 29th, 2006

Dynamic lookup cache is used in case of connected lookups only, It is also called as read and write cache, when a new record is inserted into the target table, then cache is also updated with the new ...

rma

• Nov 24th, 2006

Dynamic Lookup generally used for connect lkp transformation, when the data is cgenged then is updating, insert or its leave without changing .....

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

when data from a single source needs to be loaded into multiple targets And multiple target has primary foreign key relation constraint based loading is used For example :  In the first ...

Phani

• Feb 16th, 2007

Hi,when data from a single source needs to be loaded into multiple targets, in that situation we use constraint based load ordering.Note: The target tables must have primary - foreign key relationships.regards,Phani...

Answer Question  Select Best Answer

pawarpossible

 Profile Answers by pawarpossible Questions by pawarpossible

• Jul 2nd, 2010

Check which constarint is getting violated in log and take the action accordingly.

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

You have set the session for constraint-based loading, but the PowerCenter Server is unable to determine dependencies between target tables, possibly due to errors such as circular key relationships. Action: Ensure the validity of dependencies between target tables

Answer Question  Select Best Answer

what do u mean by Confirmed Facts? where it ll use? what is the use of it?

vamsi.yalla

• Dec 17th, 2006

Confirmed facts are reusable and fixed in nature

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

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

Besides session log, it also creates the following files if applicable - reject files, target output file, incremental aggregation file, cache file

opbang

 Profile Answers by opbang Questions by opbang

• Oct 4th, 2006

Session Log file and Session Detail file

Answer Question  Select Best Answer

srinivas vadlakonda

• Oct 11th, 2006

transaction can occur without the measure fore example victim id

opbang

 Profile Answers by opbang Questions by opbang

• Oct 4th, 2006

Factless Fact table are fact table, which is not having any measures.  For example  - You want to store the attendance information of the student.  This table will give you datewise, wh...

Answer Question  Select Best Answer